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