See how to use Names cells to navigate quickly for one location to another in a workbook.
This is a logical (beginning to end) story about most of the use for Excel Names. In this series you will see 12 amazing uses for Excel Names (14 total Name Tricks).
Great explanation.
Any ideas how to relative name a single cell in VBA that doesnt try to reference the original sheet it was created in please?
WiresAnSteel 1 year ago
I do not know, Try this great site for Excel VBA questions:
mrexcel..com/forum
ExcelIsFun 1 year ago
Name trick makes it so easy to move around within a wooksheet or between different wooksheets. Great stuff !
microsuez 3 years ago
Dear microsuez,
Yes, the Go To feature of names is EXCELlent!!
--ExcelIsFun
ExcelIsFun 3 years ago