Define name Problem


Posted by Norman on June 13, 2000 5:53 AM

A problem has arisen.

I'm using Define name application in which I have 4 Values. And of course they are linked to the particular Sheet.

Is there a way that it can "refer to" all Sheets in Workbook? at the moment it is linked to the 1st sheet "Sheet1"

I.e. each sheet uses the same Cell range specific to that sheet (say A1:A10 & B1:B10 and as all data is different on each sheet).

So therefore sheet2 will be linked to A1:10 & B1:B10 on that sheet, sheet3 will be linked to A1:10 & B1:B10 on that sheet etc etc.

Is this clear enough for anyone to help me out.

Norman



Posted by mads on June 16, 0100 2:06 AM


Not sure that this is what you're looking for, but try putting this in the RefersTo box :-

=!A1:A10

mads