Search results 138

  2. Search results
  3. pass
Sorted from new to old.
Card image
QTexts_Min

Returns minimum quarter of 2 strings representing quarters, like 1Q2024, 3Q2015, ...

Jul27
Card image
ANStrVLookupAll

Retuns list of all matchings after doing vlookups to return item from 2-dim ...

Jun14
Card image
Add bulk rows to DB Table

Inserts multiple rows into DB table as whole Unlike

May27
Card image
MatchIf7

Finds the row of 7 columns matching 7 values with options of < > <> and <= ...

May2
Card image
ANmaUploadFTP_Script + ANmaUploadFTP_1File

Uploads 1 file to FTP. It will create temp script to login to FTP and uploads ...

Apr27
Card image
TemplateLine_10Xs

Two functions to automate the replacing of variables inside a long string. Up ...

Mar16
Card image
ListBox_Read and ListBox_Save

Reads or saves to a certain column in multi-column listbox in VBA Userform Can ...

Mar11
Card image
ToggleCells

Toggle a value through list of cells in a range Pass current value and range ...

Feb2
Card image
Toggle5Values

Toggles among up to 5 values. Pass the current values, then up to 5 values (in ...

Feb2
Card image
HTMLTable_FindTable

Reads < table .... < /table> found after index Have ability to opnly bring the ...

Jan12
Card image
Match6_Until

Searches for six values in six columns and return the row number if all found, ...

2024Nov28
Card image
ArraySort_3Cols

Returns the Array of 3 cols after sorting it

2024Nov18
Card image
SettingRead_Bulk

Reads list of passed SettingNames with defined separator from Settings and ...

2024Nov3
Card image
ANmAddress_Value

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

2024Oct31
Card image
CountColumnCells_Unique

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

2024Oct6
Card image
ANmAddressSame

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

2024Sep24
12...89