Cyberdude
06-15-2006, 02:00 PM
When I define a name for cell A1, then Excel creates the ?Refers to? formula by prefixing the active sheet?s name to the A1 so it looks like: =Sheet1!$A$1.
My question is, can I define a name so that it will refer to the cell A1 on whatever the active sheet happens to be at the moment? In other words, can the definition be made so that the ?Refers to? listing omits the sheet name prefix?
A variation of this question is: can I define a name so that it would apply to only certain sheets, and not to others?
This would be handy if I want to write a date/time stamp in the same location of each sheet that I update.
My question is, can I define a name so that it will refer to the cell A1 on whatever the active sheet happens to be at the moment? In other words, can the definition be made so that the ?Refers to? listing omits the sheet name prefix?
A variation of this question is: can I define a name so that it would apply to only certain sheets, and not to others?
This would be handy if I want to write a date/time stamp in the same location of each sheet that I update.