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
ConcatenateStrings_AmongString
Collect strings matching search from a longer string. I used it to concatenate ...
Jan17
SheetTabColor
Applies certain color to sheet tab in Excel. ColorNumber is Excel ColorIndex. ...
Aug17
CountDuplicates
Counts how many duplicates found in a range of Excel cells. Basically how many ...
2020Oct31
SortedFiles
Get a sorted list of files in a directory using the File System Object (FSO) ...
2020Aug11