defining cell names in more than one worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Call me stupid, but I've read the specific responses to this question on 4/12, 4/27 and 4/28 but for the life of me can't get it to do what I want. Which is: say I've named cell A1 in Worksheet1 "FV" which is used in a formula that is consistent in Worksheets2, 3, etc.-that is it refers to the LOCAL cell A1 for each of those worksheets, and can be a different value for each. If I copy Worksheet1 and rename it, then yes, it works fine - ie. FV is peculiar to cell A1 in each Worksheet. However, if I create a new worksheet and try and name cell A1 "FV", it either defaults to Worksheet1!A1 or I end up overwriting FV to be NewWorksheet!A1 which becomes the new global value for FV and perpetuates the problem. Hope this is clear...all I want to do is find out how to go to one worksheet after another and define A1 as FV for that worksheet only. Thanks.
 
Hmmmm, same question, slightly different subject line, verging on bad
manners...

Spearfisher said:
Call me stupid, but I've read the specific responses to this question on
Click to expand...
4/12, 4/27 and 4/28 but for the life of me can't get it to do what I want.
Which is: say I've named cell A1 in Worksheet1 "FV" which is used in a
formula that is consistent in Worksheets2, 3, etc.-that is it refers to the
LOCAL cell A1 for each of those worksheets, and can be a different value for
each. If I copy Worksheet1 and rename it, then yes, it works fine - ie. FV
is peculiar to cell A1 in each Worksheet. However, if I create a new
worksheet and try and name cell A1 "FV", it either defaults to Worksheet1!A1
or I end up overwriting FV to be NewWorksheet!A1 which becomes the new
global value for FV and perpetuates the problem. Hope this is clear...all I
want to do is find out how to go to one worksheet after another and define
A1 as FV for that worksheet only. Thanks.
 
You are right but not my fault...website said my question "could not be accepted at this time", so I tried again but couldn't remember exactly the subject line. I actually got the same error message so gave up only to find later that indeed both questions were posted. Sorry.

Thank you for your help, above.
 
Back
Top