Search results 309

Sorted from new to old.

ShapeCreate_SomeVariables

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

Sep30

ShapeDelete

Safely remove certain shape from worksheet

Sep30

Shapes_HideShow

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

Sep30

Create Tree from 3 columns (Sheet2Tree)

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

Aug7

JSon_Read_aText

Reads all json files generated by aText Sync command (screenshots) from certain ...

Jul27

QTexts_Min

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

Jul27

CutString_JsonKeyValue

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

Jul27

Icon as text - CmdCaption_ChrW

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

Jul17

UnicodeToChrW

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

Jul17

ANStrVLookupAll

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

Jun14

ANStrVLookup

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

Jun14

Header font name and size in VBA

Looks like it is not easy to change font name, size and style for a header or ...

Jun1

ANmaSearch_AnyWord_FromANStr

Checks if string has any word from ANStr inside it Unlike

May26

ANStrSort2

Sorting items inside ANStr, this one in ASP Classic (VBScript) Like the VBA ...

May25

ANmaCountChars_Direction

Counts how many times we found OfChar repeated in TheStr from one of two ...

May24

Str2Clean

Cleans string. Just another function to clean string from unwanted characters

May22

1 2 ...19 20