Search results 60

Sorted from new to old.

HTMLdd_Fromdt

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

Aug19

ListBox bug with TabIndex

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

Apr15

EdgarCIK

Search for company long name in Edgar and returns its CIK Using SEC.gov site ...

Feb25

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 taht 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

ANmaHTMLContent

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

2023Jul1

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

1 2 3 4