Search results 162

Sorted from new to old.

ANmaTableAddress

Returns the full name of table with its sheet name to be used in formulas or in ...

Sun 9AM

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

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

MathInsideText

Return string after applying math to each number found inside the string. ...

2025May8

ListBox_Read and ListBox_Save

Reads or saves to a certain column in multi-column listbox in VBA Userform Can ...

2025Mar11

Match6_Until

Searches for six values in six columns and return the row number if all found, ...

2024Nov28

1 2 ...10 11