ANmaCellFormat

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

MatchIfUp or MatchIfRev

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

ContainerHTMLTag_ReturnBlock

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

CopyFiles Excel-Macro

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

CopyFiles.zip

OneDrive Reset

Reset OneDrive because I am a heavy OneDrive user. Most recent instructions, ...

SwitchTextinCells

Switch text inside cells with another text. This was needed to correct an bug ...

Send workbook as email attachment

Retro way to send a workbook you are in as an email. Found it in one of my old ...

Lazy image loading + placeholder

Setup lazy image loading plus setting placeholder to images. Using

Install/Uninstall SQLNativeClient DB driver

Install/Uninstall SQL DB driver. SQLNCLI.msi that is needed when you do ...

SQL instr

Searching for a string inside a string in SQL. You may say it is the instr in ...

HTMLTagID_Previous

Return id for any html tag that was found above certain location of html page. ...

RangeValues

Returns values of all cells in range into 1 string Only non-blank values ...