Search results 80

Sorted from new to old.

DateOffset_FromMMDD

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

Thu 8AM

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

QTexts_Min

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

2025Jul27

Calculation_StaleValues

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

2025Jun30

ANmAraDate

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

2025Jun12

Add bulk rows to DB Table

Inserts multiple rows into DB table as whole Unlike

2025May27

ImageMSO list

List of all images in ImageMSO used in ribbon as well in other parts of VBA in ...

2025Apr30

ConditionalFormatting_ColorARow

Adds conditional formatting to color a row in table based on output of formula ...

2024Nov10

ConditionalFormatting_Clear

Clears all conditional formatting in a range in a sheet in a workbook.

2024Nov10

Sheet_RowID_Generate + _LastUsed

Generate random unique ID in a column as IDyyyymmRRRR And the second function ...

2024Nov3

ANmaRead_1stFile

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

2024Aug11

SettingSave + SettingRead for NumberFormat

Reads or applies certain NumberFormat to cell in settings. Same patterns as ...

2024Apr19

ANmaCellFormat

Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...

2024Apr18

DateDateDate

Finds three dates after each other in one paragraph. Needed to locate numbers ...

2024Mar3

1 2 3 4 5