Search results 332

Sorted from new to old.

ANstr_Column

Reads and concatenate the full HTML or non-HTML of column (ColumnID) from HTML ...

2024Jul29

ANmaSpecialFolders

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

2024Jul26

DateDiff_Networkdays

Calculates no of workdays between two dates. Option to use international ...

2024Jul25

CountRowCells

Counts how many cells with data in a row, starting from certain column until ...

2024Jun22

MatchIf6

Searching for row have 6 matches found in 6 different columns, because we had 5, ...

2024May31

CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

2024May1

SettingSave + SettingRead for NumberFormat

Reads or applies certain NumberFormat to cell in settings. Same patterns as ...

2024Apr19

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

Just learnt that now

Looks like we cannot have filename (having no extension) and folder in same ...

2024Mar5

FindAncherURL_InHTMLRow

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

2024Mar4

EdgarCIK

Search for company long name in Edgar and returns its CIK Using SEC.gov site ...

2024Feb25

CutString11

Cuts long string from certain character to certain character with option to ...

2024Feb24

ANStrSort3

Sort list of texts having cell address by cell address as alphanumeric in Asc ...

2024Feb20

Free online tools - convertcase.net

Bunch of online some text and image tools, helpful for most online users these ...

2024Feb15

Send workbook as email attachment

Retro way to send a workbook you are in as an email. Found it in one of my old ...

2024Feb14

1 2 ...4 ...20 21