Define a generic name

  • Thread starter Thread starter Nelson
  • Start date Start date
N

Nelson

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 said:
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 ?
Click to expand...

Try this:

=INDIRECT("A1:A100")
 
How do you intend to use the name Date?

You can do something like this:

Insert>Name>Define
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.
 
Just a warning...

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