Search results 616

Sorted from new to old.

Custom Excel UI ribbon

Excel custom ribbon in details. A good article I use as reference to add custom ...

2025May11

MatchIf8

Searches for 8 cells in 8 columns and returns the row number if all found. Has ...

2025May10

MathInsideText

Return string after applying math to each number found inside the string. ...

2025May8

Tabs-Auto-To-Menu

Turns tabs into menu based on available width. JS (Bootstrap 5) code to turn ...

2025May4

ImageMSO list

List of all images in ImageMSO used in ribbon as well in other parts of VBA in ...

2025Apr30

ANmaNotMatch

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

2025Apr19

FirstDuplicatedItem

Returns the value of first duplicated item found in a range. This is to ...

2025Apr18

VBInstr_Rev_Any

Finds first match of string inside another in reverse order. From right to left ...

2025Apr11

NumberBeforeString

Returns number if found before certain word in larger string. This can be used ...

2025Apr10

ANmaHideIntoJPG and ANmaExtractFromJPG

Hide files into jpg and restore it using those two functions. Attached file ...

2025Apr2

VBA/Excel Registry hacks

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

2025Mar12

ANmaSafeDeleteFile

Deletes file safely without warnings or error messages. Tries to delete it at ...

2025Mar10

CutString_ANmaRules

Extract certain text from another text based on Rules defined, like extracting ...

2025Feb26

HTMLTableRow_LastRowWithData

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

2025Feb19

TrimLines

Remove all line breaks from text from a text. Not like

2025Jan31

ANStrFind_AndOrRemove

Checks (and/or removes) if an item was found in list of items and return 1 if ...

2025Jan12

1 2 ...38 39