Search results 137

Sorted from new to old.

MatchIfUp_DateTime

Finds first cell in column that is a date/time from bottom to top (technically ...

Tue 4AM

SetAllPictures_MoveAndSize

Set shapes to "Move and size with cells" All shapes inside a sheet (or all ...

Jul26

ANmaTable_FieldValue_Concat

Concatenates fields in certain row each with its header and returns the full ...

Jul26

ANmExcelTableAddress

Returns reference of a table in Excel workbook. This is because not all tables ...

Jul24

ItalicTextbox_Partial

Set part of textbox to italic, starting from StartingChar found in text until ...

Jul16

ColorTextbox_Partial

Set part of textbox to certain color, starting from certain character found in ...

Jul16

ANmExcel_Replace

Replace text in cell using Excel built-in Replace function. Ability to do ...

Jul10

ANmaFormatLastRow

Format last row found/added in Excel range to certain color. ColorText is the ...

Mar26

BoldTextbox_Partial

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

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

UsedRange

Returns the address of first:Last cells with data in sheet. Like pressing ...

2025May12

1 2 ...8 9