Search results 140

Sorted from new to old.

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

IsNumericChar

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

2024Aug21

QuickEncrypt plus others ...

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

2024Aug15

DownloadFile_Safe

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

2024Jul27

ANmaSpecialFolders

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

2024Jul26

CalculateQuarterText

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

2024Jun10

Q_NoOfdays

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

2024Jun9

Files_FoundHours

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

2024Apr30

ANmaCellFormat

Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...

2024Apr18

SortArea4

Sort range of cells by up to 4 columns. Can use any of these columns, not ...

2024Apr15

ContainerHTMLTag_ReturnBlock

Returns the full string starting from open tag of container where LocationIndex ...

2024Apr3

Concatenate_HTMLColumn

Build a string from a certain column in html table (using < table, < tr, and < ...

2024Mar14

1 2 ...8 9