Search results 173

Sorted from new to old.

VBInstr_Any

Returns the index where any of the words from AnStrSearchFor found in SearchIn ...

Sun 7AM

SSL/TLS certificate add/update

Always found myself struggling when applying security to websites for the past ...

Nov7

Match3_3rdNot0

Searches for two cells in two columns then checks for 3rd column if not equal ...

Nov2

Match4_4thNot0

Searches for three cells in three columns then checks for 4th column if not ...

Nov1

CountColumnCells_Unique

COunts unique cells found in a column. Passing sheetname, workbook name and ...

Oct6

RoundUp2

Rounds a number to nearest identifier up. Like 105 up to nearest 20 ...

Oct1

Excel 2408 bug

Serious bug in Office update that was pushed Aug 26th. At least from Excel ...

Sep10

Get boot time

Get the last time Windows 10 was started. Needed this quickly for research.

Sep6

MouseDown and MouseUp in FM20 controls

Full story of MouseDown and MouseUp in FM20 controls

Aug15

ANmaCellChar_Superscript_Subscript

Sets certain character inside a cell as superscript or subscript

Aug11

Daily folder

Create daily folder in specific location automatically. I used to have .bat ...

Jul28

ANmaSpecialFolders

Returns path for a specific special folder in system Passing the name of that ...

Jul26

DateDiff_Networkdays

Calculates no of workdays between two dates. Option to use international ...

Jul25

ANStr_Add10IfNotBlank_NorNA

Concatenate string into one, if not blank and not N/A It looked stupid for me ...

Jul24

ANStr_RemoveDuplicates

Removes duplication in ANStr separated by a separator.

Jul13

JSON_To_Table

An attempt to read json into table. This one is a work in progress, tested and ...

Jun6

1 2 ...10 11