Search results 90

  2. Search results
  3. edit
Sorted from new to old.
Card image
VBA/Excel Registry hacks

Set of hacks to modify Excel/VBA settings using Windows registry (Regedit) ...

Mar12
Card image
Match3_3rdNot0

Searches for two cells in two columns then checks for 3rd column if not equal ...

2024Nov2
Card image
Match4_4thNot0

Searches for three cells in three columns then checks for 4th column if not ...

2024Nov1
Card image
ANmAddressRefStyle

Returns type of the cell address, A1 or R1C1 If multiple cells passed, the ...

2024Sep23
Card image
RegSave, RegRead, RegDelete

Windows Registry read, save and delete branch node or key. Three functions use ...

2024Sep15
Card image
CutString96_NumberX

Extract a full number from string block having 1 or more full numbers. Like ...

2024Aug2
Card image
Q_NoOfdays

Calculates number of days for certain quarter, starting from given quarter with ...

2024Jun9
Card image
CutString97

Cuts part from large string from certain character to certain character with ...

2024Jun5
Card image
Min_No0s

Getting the minimum number from an array excluding zeros. Edit 2025-03-11: ...

2024Jun5
Card image
ANmaHTMLTables_Combine2

Combine strings of two HTML tables into string of one table. Edit 2024-10-31: ...

2024May16
Card image
MatchIF5

Searching for rows having 5 values in 5 columns Like

2024May6
Card image
CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

2024May1
Card image
MatchIf2Up

Search for 2 items in 2 columns starting from last row upword (Starting with ...

2024Apr29
Card image
SortArea4

Sort range of cells by up to 4 columns. Can use any of these columns, not ...

2024Apr15
Card image
MatchIfUp or MatchIfRev

Searching for an item in a column from bottom to top. Will search for item in ...

2024Apr8
Card image
ContainerHTMLTag_ReturnBlock

Returns the full string starting from open tag of container where LocationIndex ...

2024Apr3
12...56