Search results 718

Sorted from new to old.

Custom Excel UI ribbon

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

Sun 2PM

MatchIf8

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

Sat 3PM

Tabs-Auto-To-Menu

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

May4

ANmaUploadFTP_FilesListto1Folder

Creates script to upload list of files found in column. Will upload all files ...

May1

ImageMSO list

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

Apr30

ANmaNotMatch

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

Apr19

FirstDuplicatedItem

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

Apr18

ANmaRow_Duplicate1

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

Apr17

VBInstr_Rev_Any

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

Apr11

NumberBeforeString

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

Apr10

ANmaHideIntoJPG and ANmaExtractFromJPG

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

Apr2

VBA/Excel Registry hacks

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

Mar12

ListBox_Read and ListBox_Save

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

Mar11

ANmaSafeDeleteFile

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

Mar10

CutString_ANmaRules

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

Feb26

HTMLTableRow_LastRowWithData

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

Feb19

1 2 ...44 45