Search results 59

Sorted from new to old.

ANmExcelTableAddress

Returns reference of a table in Excel workbook. This is because not all tables ...

Jul24

ANmaTableAddress

Returns the full name of table with its sheet name to be used in formulas or in ...

Apr26

Shapes_HideShow

Hides or shows multiple shapes in a sheet in Excel, using one line command ...

2025Sep30

punycode

Encode or Decode Punycode used in domain names that are not in English ASCII ...

2025Jun8

MatchIf7Up

Returns row number having 7 values in 7 columns if all found. With option of < ...

2025May3

MatchIf7

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

2025May2

ANmaNotMatch

Finds first item from RngAddr that is not listed in InRngAddr Returns the item ...

2025Apr19

ANmaRename2Files

Quick batch file to rename two files. One of my big sources of images for my ...

2025Mar16

ToggleCells

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

2025Feb2

Toggle5Values

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

2025Feb2

SettingRead_Bulk

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

2024Nov3

CountColumnCells_Unique

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

2024Oct6

Choose2

Returns a value based on an ID. If ID is 1, return 1st value, If ID is 2, ...

2024Aug20

HTMLTable_FullRow_NonBlanks

Returns all numeric values in row separated by Sepa Only cells that are not ...

2024Aug7

ANmaSpecialFolders

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

2024Jul26

MatchIf6Up

Searches for 6 values in 6 columns and return the row number found in. ...

2024May31

1 2 3 4