Search results 74

Sorted from new to old.

ANmaSearch_AmpFriends

Searches for string inside string with multiple possibilities if the char & ...

Jul7

ANmAdd_ThenSort_2Columns

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

Jun1

ANmaSearch_ApostropheFriends

Searches for string inside string with apostrophe variations conversion

May27

ANmaHTMLTables_Combine2

Combine strings of two HTML tables into string of one table. Edit 2024-10-31: ...

May16

ANmaCellFormat

Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...

Apr18

ANmaRemoveNestedTags

Remove tags that are identical and nested inside each other in an HTML document, ...

Feb4

3 Custom BS buttons

3 Custom-made button colors using Bootstrap. Because I suck at graphics, I ...

Jan21

ANmaPivotTable_Clear

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

2023Dec22

ANmaNumber_Closest2Word

Finds the number between two spaces that is found close to of Word1Location ...

2023Oct24

ANmaFilter3

Filter database into new sheet, by copying certain columns only, not whole ...

2023Oct13

WorkbookSave_ANmar

Saves a workbook handling several scenarios and decide what to do based on each. ...

2023Aug9

ANmaHTMLImgDownload

Downloads image from src of < img html tag after searching for list of ...

2023Aug2

ANmaHTMLContent

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

2023Jul1

ANmaInt

Cuts the integer part of a number. Like INT, FIX, or CINT I know we already ...

2023May2

ANmaDate

Returns date in human format. Which is as follows... Just day name (and time) ...

2023Apr27

ANmaVLookup

Finds first occurrence of item in column, then returns value from same row as ...

2022Dec23

1 2 3 4 5