Create a defined name that refers to =B1. Note that this differs
from typical defined names in that it uses relative rather than
absolute references (no dollar signs in the formula).


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"John Broderick" wrote in message
...
For example I want to create a name (CellBelow) that always
refers to the
cell below the active cell.
I know how to do this with Insert Name / Define, but how does
one do it
within VBA?

Thanks,
JB