Define a generic name
How do you intend to use the name Date?
You can do something like this:
InsertNameDefine
Name: Date
Refers to: =INDIRECT("A1:A100")
Then, Date will refer to A1:A100 of the sheet where you use the name. For
example, if you enter this formula in cell B1 of Sheet2:
=SUM(Date)
You'll get:
=SUM(Sheet2!A1:A100)
The big problem with this is that it will *always* refer to A1:A100. So if
you were to insert new rows/columns that would change the range, the
referenced range *won't* change.
--
Biff
Microsoft Excel MVP
"Nelson" wrote in message
...
I have created a template which will be used to create customer profiles
problem here is I want to use names (example Cells A1:A100 = date) without
associating it to the name of the worksheet.
So instead of Date = worksheet1!A1:A100 , I just want Date = A1:100
Can this be done ?
--
Nelson
|