Search results 503

Sorted from new to old.

DateOffset_FromMMDD

Calculate the new MMDD from a date formated as MMDD after adding/subtracting ...

Apr9

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

ANmaDailyFolder

Creates folder daily in certain folder using certain mask (daily or any other ...

Feb11

Formulas_FromFile_ToRow

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

2025Oct11

Formulas_FromRow_toFile

Exports all formulas in a row of sheet into text file.

2025Oct10

Create Tree from 3 columns (Sheet2Tree)

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

2025Aug7

QTexts_Min

Returns minimum quarter of 2 strings representing quarters, like 1Q2024, 3Q2015, ...

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

Outlook data files

Custom default location for Outlook data files. Tell Outlook to always store ...

2025Jun18

ANStrVLookupAll

Retuns list of all matchings after doing vlookups to return item from 2-dim ...

2025Jun14

ANStrVLookup

behaves as vlookup to return item from 2-dim ANStr Can choose which column, ...

2025Jun14

ANmAraDate

Format full date in Arabic language using several known Arabic month syntax. ...

2025Jun12

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

DBTableCol_Array

Reads 1 column from SQL DB table and return as 1-dimension array oConn object ...

2025May30

1 2 ...31 32