Search results 468

Sorted from new to old.

ANmaTableAddress

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

Apr26

FormatNumbers_InsideText

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

Mar9

Range().top below hidden rows

Hidden rows change the .top of below ranges. It turns out that the range().top ...

Jan13

ANStrColor2RGBA_Para

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

2025Dec20

Textbox_PartialBold

Set part of textbox to bold, starting from StartingChar (like : ) that found in ...

2025Nov13

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

ShapeCreate_SomeVariables

Create a shape in certain sheet with options Some other options are hard-coded, ...

2025Sep30

ShapeDelete

Safely remove certain shape from worksheet

2025Sep30

Shapes_HideShow

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

2025Sep30

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

CutString_JsonKeyValue

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

2025Jul27

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

ANmAraDate

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

2025Jun12

1 2 ...29 30