CleanArray

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

Frm81 - FullDetails

Show window of details, can be used to show content for certain cell, or show ...

Frm81.zip

Frm6 - ANmaMultiSelect

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

Frm6.zip

Row_PixelLocation

Gets the cell row where a certain shape is located by passing shape.Top number ...

SumOf_3Filters

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

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

UI_2ValidationsUpdate

Apply validation on two cells, when a 3rd cell is changed When modifying a ...

Custom Excel Right-Click Menus

Customizing Excel's right click menus The following code demonstrates how to ...