Search results 761

Sorted from new to old.

ANmaTableAddress

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

Apr26

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

ANStrColor2RGBA_Para

Returns Red, Green, Blue and Transparency from text representing color Like ...

2025Dec20

Variable_PerLocation_FromFullLine

Extract set from ANstring, like 2nd set of variable list using specific ...

2025Oct16

Shapes_HideShow

Hides or shows multiple shapes in a sheet in Excel, using one line command ...

2025Sep30

ANmaUploadFTP_ANstrFilesto1Folder

Upload all files found in ANStr list of files into 1 folder. Passing all ...

2025Aug7

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

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

Icon as text - CmdCaption_ChrW

Creates an icon as text to use inside button or any frm20 controls. this will ...

2025Jul17

UnicodeToChrW

Converts a Unicode number into its ChrW text. It automatically uses surrogate ...

2025Jul17

Calculation_StaleValues

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

2025Jun30

1 2 ...47 48