Search results 60

Sorted from new to old.

HTMLdd_Fromdt

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

Aug19

HTML_CleanNumber

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

Jan31

SQL Cross Apply String_Split with XML Path

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

Jan20

Grandchildren files and count

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

Jan11

Excel clipboard bug

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

2023Dec27

ANmaPivotTable_Clear

Clears all filters in PivotTable and hide the [blank] item from list, pass ...

2023Dec22

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

ANmaHTMLContent

Reads certain part in HTML output of a page. Will search for list of strings ...

2023Jul1

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

Listbox 1st item [Any]

Allow user to select [Any] as first item in list that will deselect all other ...

2022Nov13

Dropdown button commands

A drop-down of multiple commands in pure VBA. Needed this in a large Excel-VBA ...

2022Oct12

LstCustomSelection_Refresh

Read list of items from Settings sheet, then Sort, then save, before reading ...

2022Aug31

CreateUniqueList

Create list of unique items from a column into another column This is similar ...

2022Apr26

1 2 3 4