Search results 60

Sorted from new to old.

SettingRead_Bulk

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

Nov3

HTMLdd_Fromdt

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

Aug19

ANmAdd_ThenSort_2Columns

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

Jun1

ListBox bug with TabIndex

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

Apr15

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

List_of_Names + DeleteNames

List names in a certain workbook into sheet. And Deletes those names. You may ...

2023Jul9

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

1 2 3 4