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

Nelson wrote:
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 ?


Try this:

=INDIRECT("A1:A100")

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

Just a warning...

I wouldn't use Date as the range name. It looks way too close to the excel
function =date().



Nelson wrote:

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

--

Dave Peterson