Attention Excel experts:

I wish to create the equivalent of a "local variable" within a Microsoft
Excel worksheet.
ie the variable refers to a cell or cells on the worksheet where it
appears. If the cell is copied to another worksheet it then refers to the
corresponding cell on the new sheet.
(I appreciate that this introduces risks from sheet structure differences).

When referring to cells that correspond to variable names Excel uses the
format

          =3D'Sheet_name'!$X_Ref$Y_Ref

Editing the address associated with a name to remove  'Sheet_name' causes
an  error message.
Creating a name without a sheet address therein seems undoable.

This requirement MAY be able to be addressed if there is a Worksheet name
which means "the_worksheet_that_this_formula_is_on" or "This _sheet".
If such exists I know it not.

Does anyone know how to do this?
I have tried Excel help, web searched and tried everything that came to
mind.

I'm using Excel 2002 but have newer and older versions avail;able, but
doubt that a solution would be version specific.
__________________

eg if I have a worksheet
with cells named
    SUM1, SUM2, SUM3
referring to absolute names
    A1, B2, C3 in a that sheet

I wish to be able to replicate the sheet and

have the variables
    SUM1, SUM2, SUM3
refer to cells
    A1, B2, C3  on the new sheet

If I create a new worksheet and copy the old one to it the names refer to
cells in the old sheet.

_______

When referring to cells that correspond to variable names Excel uses the
format

          =3D'Sheet_name'!$X_Ref$Y_Ref

Where Sheet_name is either a user assigned name, or Sheetn (n =3D 1,2,3, ..=
..)
if the sheet has not been renamed after creation.

During name creation using 'Insert Name Define' the location referred to
can be altered with the cursor keys or deleted from right to left in whole
or in part and retyped BUT created addresses with the 'Sheet_name' portion
of the name can be entered but return an error message.


                   Russell McMahon
--=20
http://www.piclist.com/techref/piclist PIC/SX FAQ & list archive
View/change your membership options at
http://mailman.mit.edu/mailman/listinfo/piclist
.