Search results 75

Sorted from new to old.

ANmExcelTableAddress

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

Fri 9AM

File1st_Attributes_In

Gets details of first file found in folder, based on requested order, byt name, ...

May31

ANmaTableAddress

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

Apr26

FormatNumbers_InsideText

Formats all numbers found inside text to certain format. Excluding numbers ...

Mar9

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

Non-English IDNs

Online tool to encode or decode IDNs Domain names with characters other than ...

2025Jun4

Header font name and size in VBA

Looks like it is not easy to change font name, size and style for a header or ...

2025Jun1

FilesIn_4Array

Returns list of file names along with path, date modified and size in array of ...

2025May25

MatchIf7

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

2025May2

ANmaRename2Files

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

2025Mar16

FilesIn2 - sorted files

List of files, sorted by name, size or modified date ascending or descending. ...

2024Nov25

ArraySort_3Cols

Returns the Array of 3 cols after sorting it

2024Nov18

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

ANmaRead_1stFile

Returns information about first file name found after sorting matching files in ...

2024Aug11

1 2 3 4 5