Contents Bayley, CPRGreaves, Canon, Chris, ChrisGreaves, Create, DeleteIllegalReferences, DeleteMyRangeNames, DumpRangeNames, Error, FabNameCollection, FabNameLeft, FabNameLeftSelection, FabNameUp, FabNameUpSelection, Finding, Formulas, FormulasToRangeNames, Garden, Greaves, House, Landfall, LocalizeRangeNames, Macro, Making, Manage, Names, Range, Remove

709-218-7927

The Landfall Garden House

60 Canon Bayley Road

CANADA A0C 1B0

Christopher Greaves

Error! Not a valid filename.

Range Names

Remove all formatting, delete empty columns and rows, generally remove any distraction from the calculation structure of the workbook.

Seq	Macro	Description
1	FabNameLeft
2	FabNameLeftSelection
3	FabNameUp
4	FabNameUpSelection
5	FabNameCollection
6	DeleteMyRangeNames
7	DumpRangeNames
8	DeleteIllegalReferences
9	CellReferencesToRangeNames
10	RangeNamesToCellReferences
11	Formula1ToRangeNames
12	FormulasToRangeNames
13	LocalizeRangeNames

Create Range Names

We provide versatile methods of creating range names from text labels.

FabNameLeft

FabNameLeftSelection

FabNameUp

FabNameUpSelection

FabNameCollection

Manage Range Names

Finding out what’s there and deleting it.

DeleteMyRangeNames

DumpRangeNames

DeleteIllegalReferences

Range Names in Formulas

Making use (and dis-use) of range names in formulas.

CellReferencesToRangeNames

RangeNamesToCellReferences

Formula1ToRangeNames

FormulasToRangeNames

LocalizeRangeNames

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