Contents AutoFitAllRowsInWorkbook, Autosizing, Bayley, CPRGreaves, Canon, Cells, Chris, ChrisGreaves, ColorIndex, Error, Format, Garden, Greaves, House, Landfall, Macro, Road, STAIN, StainSelection, StainWorkBOOK, StainWorkSHEET

709-218-7927

The Landfall Garden House

60 Canon Bayley Road

CANADA A0C 1B0

Christopher Greaves

Error! Not a valid filename.

Format

Seq	Macro	Description
1	StainSelection
2	StainWorkSHEET
3	StainWorkBOOK
4	AutoFitAllColumnsInWorksheet
5	AutoFitAllColumnsInWorkbook
6	AutoFitAllRowsInWorksheet
7	AutoFitAllRowsInWorkbook

Staining Cells

We STAIN the formulae; this isolates raw data or reference data from calculations.

StainSelection

For the selection, all cells which contain a formula are stained with a color.

The color is hard- wired to be ColorIndex=6, also known as biological-hazard-yellow.

StainWorkBOOK

For all worksheets in the current workbook, all cells which contain a formula are stained with a color.

The color is hard- wired to be ColorIndex=6, also known as biological-hazard-yellow.

StainWorkSHEET

For the current worksheet, all cells which contain a formula are stained with a color.

The color is hard-wired to be ColorIndex=6, also known as biological-hazard-yellow.

Autosizing Cells

AutoFitAllColumnsInWorksheet

AutoFitAllColumnsInWorkbook

AutoFitAllRowsInWorksheet

AutoFitAllRowsInWorkbook

Bonavista, Thursday, December 17, 2020 7:23 AM