CleanArray

Cleans array of unwanted items This usually needed after you merge two arrays, ...

merge2Arrays

Merges two 1-dimension arrays and return an array Both should be 1 dimensional ...

Frm6 - ANmaMultiSelect

Give users ability to multi-select from list of items into cells with separator. ...

Frm6.zip

RandomUniqueID_Sheet

Inserts numeric random unique ID in a column in sheet, specify column, sheet, ...

Execute exe embedded in Excel

Execute exe file that embed inside Excel sheet This is for experimental, not ...

HTML5 tags cheatsheet

A simple graphic illustrates the new HTML5 tags and differences against old ones

Excel crashes when File > Print

During generating Print Preview, Excel crashes. Applies to some files, not all, ...

Vertical page breaks

Change Vertical page breaks in Excel spreadsheet preparing to print Looks like ...

InSheet_ChangeImage

Allows users to inserts image into sheet, replacing old one, with ability to ...

SumOf_3Filters

Returns sum of certain column in range (or table) in sheet after applying ...

EnvironList

List of all variables of Environ It will populate them in sheet range starting ...

Generate_PowerPoint

Creates PowerPoint slideshow file from Excel range(s) with slide per sheet (or ...