Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
A couple of questiosn on Named Ranges
1) I believe it's possible to use the same name on separate worksheets of the
same workbook but I can't work out how, the Insert ¦ Name command doesn't seem to give me an option and all names I put in seem to be 'global' 2) I (accidentally) put the name of a cell being referred to in single quotes and when the cell it was in dragged or copied the name referred to changed. (ie. the single quotes are doing the opposite of dollar signs on a normal A1 style cell reference.) However although I did this once unintentionally I have been unable to repeat what I did Thanks in advance Simon |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mass Creation of Named Ranges? | Excel Discussion (Misc queries) | |||
Named Ranges | Excel Worksheet Functions | |||
dynamically building references to named ranges | Excel Discussion (Misc queries) | |||
Like 123, allow named ranges, and print named ranges | Excel Discussion (Misc queries) | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |