Search results 124

Sorted from new to old.

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

ANmaCellFormat

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

Apr18

SortArea4

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

Apr15

Concatenate_HTMLColumn

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

Mar14

FindAncherURL_InHTMLRow

Finds the URL (href tag value) for an anchor inside a table row (tr element) ...

Mar4

1 2 ...7 8