IsError_Range

Checks if range has at least one error in a range of cells Fast, and simple

RowList_Matching

Returns list of rows numbers having cells matching text in a column. Passing ...

Subtotal_Indirects

Finds the SUM, COUNT, COUNTA, etc for a range of cells referencing using ...

setSelectedIndex byname and byval

Set active (Selected) item in listbox using javascript Imported and modified ...

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 ...

Vertical page breaks

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

ANmaCopy_Objects

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

CellSave and CellRead

Reads a cell or Saves value into certain cell, in certain sheet and workbook. ...

Graphbar

Interactive graph bars, will go deeper when you click on the bar Originally ...

GraphBars.zip

CreateList_Matching

Creates list of items found in rows, where these rows match a value in another ...

Column2AnString_Unique

Creates list of unique items found in a column, returns string with items ...