VBA-Excel 171 Visual basic for applications that works only in Microsoft Excel, aka macros

Card image cap
EnvironList

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

Card image cap
Hiding chart in Excel

How to hide a full chart in Excel. By treating it as shape, not as chart.

Card image cap
Generate_PowerPoint

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

Card image cap
Save Excel range (or shape) to picture

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

Card image cap
BrowseImage

Asks user to select an image and returns full path and name of selected image ...

Card image cap
Quarter_to_Words

Convert Quarter code to text per special project requirements. A special ...

Card image cap
Resize_Me2 + Resize_Me3

Resizes Excel window to certain small size and location (hard-coded) and hide ...

Card image cap
ANmaCopy_Objects

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

Card image cap
ConcaUFO_RowsfromSheets

Imports rows from multiple sheets of a workbook into final sheet along with ...

Card image cap
ExitTool and DoNothing

My way of Exiting tool in case or error, also another sub that basically does ...

Card image cap
CellSave and CellRead

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

Card image cap
CountDuplicates

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