Search results 88

Sorted from new to old.

ANmaSearch_ApostropheFriends

Searches for string inside string with apostrophe variations conversion

2024May27

ANmaHTMLTables_Combine2

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

2024May16

ANmaCellFormat

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

2024Apr18

ANmaRemoveNestedTags

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

2024Feb4

3 Custom BS buttons

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

2024Jan21

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

ANmaRemoveDuplicates

Removes duplication in table in 1 or more columns using Excel ...

2022Sep25

ANmAdvancedFilter

Filter table inside Excel the fast way (using advanced filter) into another ...

2022Sep15

1 2 3 ...5 6