Codes Required

Similar codes

Card image cap
SearchinHTMLTable

Search for a word in a certain column in html table and return the full row ...

Nov12

Card image cap
VLookup_HTML

Does a search in 1st column (< td tag) in an HTML table (< table tag), and ...

Jan26

Card image cap
SaveAsHTML_Template

Creates HTML file using template found in a column. Have lines of HTML in a ...

2022Feb5

Card image cap
GetColumnName, ColumnName_XOffset

Gets the column name from a cell address. Returns "E" from "E45", or "BR" from ...

2018Jun15

Card image cap
DB_AllRows

Returns all rows found from an SQL Query as string Separated by row and column ...

2018Apr23

Card image cap
Rows 2 Cell

Convert items found in a column matching certain material into list in 1 cell ...

2019Jul30

Card image cap
ANmaRemoveDuplicates

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

2022Sep25

Card image cap
Range2Block

Concatenate all rows found in a range starting A1Cell for Columns_To columns ...

2023Mar6

Card image cap
DB_Read1Row (DB_Read1stRow)

Reads from a table in a DB Reads only the first row, and return a string ...

2018Apr21

Recently by developer

Card image cap
MatchIfUp or MatchIfRev

Searching for an item in a column from bottom to top. Will search for item in ...

Mon 10AM

Card image cap
ContainerHTMLTag_ReturnBlock

Returns the full string starting from open tag of container where LocationIndex ...

Apr3

Card image cap
Between2int and Between2intinc

Checks if number between two numbers, with or without considering those numbers. ...

Mar23

Card image cap
CopyFiles Excel-Macro

Simple macro to make sure we have a copy of all files in a folder found in ...

Mar12

Random Codes

Card image cap
Navigate_IE

Reads HTML source page of a webpage, maynot work for heavy js pages, but works ...

2021May31

Card image cap
ANmaCopy_Objects

Copies objects from cell into cell Decide Sheet, and workbooks to copy from or ...

2020Nov11

Card image cap
IsValidUTF8 + DecodeUTF8 + EncodeUTF8

Checks UTF8, or convert to/from UTF8. Simple functions to convert the first 256 ...

2018Sep5

Card image cap
CustomExcelMenu - FaceIDs

How to create custom Excel menu, this one shows the IDs and icons of 20 icons, ...

2018Jul19