Search results 295

Sorted from new to old.

Match4_Until

Search 4 columns with a stop. Tell the function to stop searching after certain ...

Fri 4AM

ArraySort_3Cols

Returns the Array of 3 cols after sorting it

Mon 5PM

VBInstr_Any

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

Sun 7AM

ANmaRemoveBlanks_1Col

Remove blank cells from 1 column

Sun 7AM

VBInstr_Any

Search for string inside another, with ability to have multiple strings to ...

Nov15

Match5_5thNot0 and Match6_6thNot0

Searches for 4 cells in 4 columns then checks for 5th column to not equal zero ...

Nov13

RegExPatternMatch

Checks string against pattern using RegEx (VBScript.RegExp). The pattern ...

Nov10

ANmAddress_Dimensions

Detects how many dimensions an address has, This is what I call it dimensions ...

Nov8

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

ANmAddress_Value

Returns the value of a cell address in another sheet. Todo: Allow to reference ...

Oct31

CleanArray_2Dim

Cleans an array of 2 dimensions from blank in 1st column. Similar to

Oct24

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

ANmAddressSame

Checks if passed addresses are referring to same cell regardless of ...

Sep24

1 2 ...18 19