Range_SaveAsImage

Exports range to an image, something we wanted to be able to do for a while now. ...

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

GetColumnIndex

Returns Id of column (Column Index) from a cell. Similar to GetColumnName, this ...

Subtotal_Indirects

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

CleanArray

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

Frm6 - ANmaMultiSelect

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

Frm6.zip

Save Excel range (or shape) to picture

This is an interesting approach to export a range of cells into picture using ...

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

CountDuplicates

Counts how many duplicates found in a range of Excel cells. Basically how many ...

Part of cells in Excel

How to modify part of text inside an Excel cell using VBA. Something in my ...