Search results 167

Sorted from new to old.
Card image
ANmaFormatLastRow

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

Card image
FormatNumbers_InsideText

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

Card image
Formulas_FromFile_ToRow

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

Card image
RangeTakePicture_Linked

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

Card image
Create Tree from 3 columns (Sheet2Tree)

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

Card image
JSon_Read_aText

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

Card image
CutString_JsonKeyValue

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

Card image
Calculation_StaleValues

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

Card image
Header font name and size in VBA

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

Card image
ANmaRemoveMultiSpace

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

Card image
UsedRange

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

Card image
1st cell of sheet range

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

Card image
MatchIf8

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

Card image
MatchIf8Up

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

Card image
ANmaNotMatch

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

Card image
MatchIf4Up

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