Search results 279

Sorted from new to old.

ANmaNotMatch

Finds first item from RngAddr that is not listed in InRngAddr Returns the item ...

2025Apr19

ANmaRow_Duplicate1

Duplicate 1 row into row below with insert using fill down or copy-paste No ...

2025Apr17

ListItemText_to_ListIndex

Finds the index of an item in listbox (or combobox) It searches for that item ...

2025Mar24

NumberBeforeString_HTML2

Cuts a number that would be found 2 words before certain word inside a block ...

2025Mar20

TemplateLine_10Xs

Two functions to automate the replacing of variables inside a long string. Up ...

2025Mar16

VBA/Excel Registry hacks

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

2025Mar12

ListBox_Read and ListBox_Save

Reads or saves to a certain column in multi-column listbox in VBA Userform Can ...

2025Mar11

HTMLTableRow_LastRowWithData

Retunes the row from bottom that has data (not blank or hidden)

2025Feb19

ANmaSum_4IFs

Applies SumIFs for 4 columns, same sheet, same workbook Another function to do ...

2024Nov13

ConditionalFormatting_ColorARow

Adds conditional formatting to color a row in table based on output of formula ...

2024Nov10

ANmAddress_Dimensions

Detects how many dimensions an address has, This is what I call it dimensions ...

2024Nov8

Sheet_RowID_Generate + _LastUsed

Generate random unique ID in a column as IDyyyymmRRRR And the second function ...

2024Nov3

HTMLCloseTag_HasWordAfter

Finds the number of occurrence of a "Numeric" inside a string having a certain ...

2024Oct6

Font-Based progress bar

Show progress bar using fonts only. Neat trick to use inside HTML or word ...

2024Sep29

ANmaFiles2List

Generating list of files in a folder. One file to do that. I know this has ...

2024Sep21

FixURL

Return safe URL after converting critical chars to whatever passed in SafeChar

2024Sep16

1 2 ...17 18