Codes Required
Similar codes
SearchinHTMLTable
Search for a word in a certain column in html table and return the full row ...
Nov12
Concatenate_HTMLColumn
Build a string from a certain column in html table (using < table, < tr, and < ...
Mar14
ContainerHTMLTag_ReturnBlock
Returns the full string starting from open tag of container where LocationIndex ...
Apr3
FilterSheet_1By1 + FilterSheet_Clear
Sets Autofilter in a sheet, and another function to clear Autofilter ...
2020Jan3
ANmaRemoveNestedTags
Remove tags that are identical and nested inside each other in an HTML document, ...
Feb4
ScrapeURL_ToSheet
Reads content of Page from URL to a sheet. This was made specially for certain ...
2023Apr4
Recently by developer
CountColumnCells_2Criteria
Counts how many cells matching 2 criterias.
Just like
May1
Files_FoundHours
Listing the file from a folder that was created during last few hours. Can ...
Apr30
Random Codes
AddDatabar_ConditionalFormatting
Adds databars conditional formatting to range of cells. Passing column, start ...
2022Aug22
Styles_DeleteNonStandard
Delete styles from an Excel workbook, any non-standard style will be deleted. ...
2018Aug12
FGColor_Calc
To set the color of the foreground based on background color to get best look. ...
2018Jun20
MatchIf (aka VMatchIf)
The best Match I created, return 0 if not found, kind of CountIF+Match ...
2018Jun16