VLookup_HTML

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

RangeValues

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

VBInstrRev

Similar to VBInstr, but this one does it in reverse, which is instrrev() ...

PivotTable_ShowHideItems

Show or hide item (or items) in PivotTable for a certain field. Passing ...

PivotTable_ShowHideBlankItems

Shows or hides an item or items in a PivotTable filter field. Passing ...

3 Custom BS buttons

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

SQL Cross Apply String_Split with XML Path

SQL select statement to convert list of IDs found in column (from more than row ...

CreateThumbSquare_IrfanView

Creates square thumb for an image, regardless of image aspect ratio It will ...

Resources.zip

ConcatenateStrings_AmongString

Collect strings matching search from a longer string. I used it to concatenate ...

Converts two bytes to long

Functions to convert two bytes to a numeric value (long), (both little-endian ...

MultiRead_JSON

Reads array of arrays from the parent and return back ANString of 3 columns

SettingRead_Ajax + SettingRead_Ajax_IntoObject

Two functions to return an output of file into object on page or back to caller ...