Search results 135

Sorted from new to old.

MatchIf7

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

Fri 1PM

ANmaUploadFTP_Script + ANmaUploadFTP_1File

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

Apr27

TemplateLine_10Xs

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

Mar16

ListBox_Read and ListBox_Save

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

Mar11

ToggleCells

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

Feb2

Toggle5Values

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

Feb2

HTMLTable_FindTable

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

Jan12

Match6_Until

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

2024Nov28

ArraySort_3Cols

Returns the Array of 3 cols after sorting it

2024Nov18

SettingRead_Bulk

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

2024Nov3

ANmAddress_Value

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

2024Oct31

CountColumnCells_Unique

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

2024Oct6

ANmAddressSame

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

2024Sep24

ANmAddressRefStyle

Returns type of the cell address, A1 or R1C1 If multiple cells passed, the ...

2024Sep23

FixURL

Return safe URL after converting critical chars to whatever passed in SafeChar

2024Sep16

Choose20

Chooses from 20 options based on the passed ID, can have any of these passed. ...

2024Sep5

1 2 ...8 9