Search results 128

Sorted from new to old.

Match6_Until

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

Nov28

ArraySort_3Cols

Returns the Array of 3 cols after sorting it

Nov18

SettingRead_Bulk

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

Nov3

ANmAddress_Value

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

Oct31

CountColumnCells_Unique

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

Oct6

ANmAddressSame

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

Sep24

ANmAddressRefStyle

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

Sep23

FixURL

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

Sep16

Choose20

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

Sep5

IsNumericChar

Checks if character is number or no. Returns True or False Number includes the ...

Aug21

QuickEncrypt plus others ...

Text encryption/decryption snippet that utilizes the powerful xICE encryption ...

Aug15

DownloadFile_Safe

Downloading file directly to machine without refreshing or going to another ...

Jul27

ANmaSpecialFolders

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

Jul26

CalculateQuarterText

Returns the text of quarter (3Q2024 or 1Q2017) with offset of the passed ...

Jun10

Q_NoOfdays

Calculates number of days for certain quarter, starting from given quarter with ...

Jun9

Files_FoundHours

Listing the file from a folder that was created during last few hours. Can ...

Apr30

1 2 ...7 8