Search results 167

Sorted from new to old.

ANmaFormatLastRow

Format last row found/added in Excel range to certain color. ColorText is the ...

Mar26

FormatNumbers_InsideText

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

Mar9

Formulas_FromFile_ToRow

Imports formulas from file into list of cells defined in file itself into ...

2025Oct11

RangeTakePicture_Linked

Converts a range in Excel sheet into picture. linked or unlinked. Important! ...

2025Sep30

Create Tree from 3 columns (Sheet2Tree)

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

2025Aug7

JSon_Read_aText

Reads all json files generated by aText Sync command (screenshots) from certain ...

2025Jul27

CutString_JsonKeyValue

Reads value from json string for certain key. Using RegEx Regular Expression. ...

2025Jul27

Calculation_StaleValues

Show Stale function formats or hide Excel recently started to show cells with ...

2025Jun30

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

ANmaRemoveMultiSpace

Removes multiple spaces from within string, those are up to 16 spaces that ...

2025May16

UsedRange

Returns the address of first:Last cells with data in sheet. Like pressing ...

2025May12

1st cell of sheet range

Returns the address of first cell in data in range, the very first cell of very ...

2025May12

MatchIf8

Searches for 8 cells in 8 columns and returns the row number if all found. Has ...

2025May10

MatchIf8Up

Searches for 8 cells in 8 columns and return the row number if all found Just ...

2025May7

ANmaNotMatch

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

2025Apr19

MatchIf4Up

Returns row of matching 4 values in 4 columns searching from bottom to top. ...

2025Apr12

1 2 ...10 11