Search results 69

Sorted from new to old.

Shapes_HideShow

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

Sep30

Create Tree from 3 columns (Sheet2Tree)

Converts 3 columns in sheet into 3-generation tree using TreeView from Mscomctl. ...

Aug7

punycode

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

Jun8

Non-English IDNs

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

Jun4

Header font name and size in VBA

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

Jun1

FilesIn_4Array

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

May25

MatchIf7

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

May2

ANmaRename2Files

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

Mar16

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

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

ANmaCellChar_Superscript_Subscript

Sets certain character inside a cell as superscript or subscript Edit ...

2024Aug11

Daily folder

Create daily folder in specific location automatically. I used to have .bat ...

2024Jul28

MatchIf6Up

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

2024May31

CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

2024May1

1 2 3 4 5