Search results 235

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

Textbox_PartialBold

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

2025Nov13

Pagebreak and Pagebreak preview

When setting the location of pagebreak, you need to have that sheet view set to ...

2025Nov11

Variable_PerLocation_FromFullLine

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

2025Oct16

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

RangeTakePicture_Linked

Converts a range in Excel sheet into picture. linked or unlinked. Important! ...

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

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

ASPZip

Zipping in ASP Classic, would love to test on my next project.

2025Jun6

1 2 ...14 15