Search results 60

Sorted from new to old.

ImageMSO list

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

Wed 1PM

ANmaNotMatch

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

Apr19

ANStrFind_AndOrRemove

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

Jan12

SettingRead_Bulk

Reads list of passed SettingNames with defined separator from Settings and ...

2024Nov3

HTMLdd_Fromdt

Extracts the innerText of < dd > < / dd> for a specific < dt> < /dt> from HTML ...

2024Aug19

ANmAdd_ThenSort_2Columns

Adds values of 2 cells into 2 columns (usually below them). I used these small ...

2024Jun1

ListBox bug with TabIndex

Setting TabIndex for a listbox to 0 in a Userform will have some issues when ...

2024Apr15

HTML_CleanNumber

Cleans block of string (HTML block) from characters that are not needed Can ...

2024Jan31

SQL Cross Apply String_Split with XML Path

SQL select statement to convert list of IDs found in column (from more than row ...

2024Jan20

Grandchildren files and count

Returns list of files in 2 level folders Will not find files as children of ...

2024Jan11

Excel clipboard bug

Looks like there is a bug in Excel when dealing with copy and paste. Excel ...

2023Dec27

ANStrFind_AndOrAdd

Checks if an item was found in list of items and return 1 if yes, 0 if not ...

2023Dec19

ReplaceStrings

Replace strings found in list of strings from inside a string, does that make ...

2023Nov11

ListPivotsInfo

List All Pivot Tables and their Sources for a given workbook into sheet. ...

2023Aug13

NumberDigitImage

Creates list of images to represents a number. Basically multiple < img > tags ...

2023May15

ScanFolder

Scans folder and its all subfolders (2 levels only) for files then put file ...

2023Apr7

1 2 3 4