defining cell names in more than one worksheet

[Spearfisher]

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.

 

[Stephen Dunn]

Hmmmm, same question, slightly different subject line, verging on bad
manners...

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.

 

[Spearfisher]

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.