Search results 749

Sorted from new to old.

Recalculate cells with UDF

Force Excel to calculate Cells with UDFs inside VBA code UDF = ...

Aug14

ANmArray_1stMatch_orPartial

Returns the 1st item found in array matching partially the search for value. ...

Aug14

Explorers

Open several windows of Windows file explorers (Explorer.exe) to certain ...

Aug2

ListBox redraw bug (fm20)

Fix to the bug that when changing item in listbox that is not visible because ...

Aug2

Notes bad for speed

Excel macros performance Adding Notes to cells does affect speed in running ...

Aug1

ANmExcelTableAddress

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

Jul24

ANmExcel_Replace

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

Jul10

DuplicatedList

Returns list of duplicated items in a range as ... ' ...

Jun21

rel nofollow

Outside link no follow. html nofollow of rel No more confusion if it is ...

Feb13

ANmaDailyFolder

Creates folder daily in certain folder using certain mask (daily or any other ...

Feb11

Hack VBE password in .xlsm

Remove VBE project password protection off of xlsm. This is screenshot on how ...

2025Dec30

Variable_PerLocation_FromFullLine

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

2025Oct16

RangeTakePicture_Linked

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

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

1 2 ...46 47