Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sheet/Cell References
Hi,
Basic One (hopefully) What is the difference between: (a) +Return!C6 and (b) +'Return (2)'!C6? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sheet/Cell References
You have a worksheet called Return, and then you did a Move/ Copy Sheet to
produce a copy of that sheet, which defaults to being called Return (2). [You'll see the names on the tabs of the sheets.] (a) points at the first of these, and (b) at the second. -- David Biddulph "veryeavy" wrote in message ... Hi, Basic One (hopefully) What is the difference between: (a) +Return!C6 and (b) +'Return (2)'!C6? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sheet/Cell References
Thanks David.
The postscript to this is I was too stupid to find the Unhide Sheets Option (i.e. only results was visible). Duh! Cheers "David Biddulph" wrote: You have a worksheet called Return, and then you did a Move/ Copy Sheet to produce a copy of that sheet, which defaults to being called Return (2). [You'll see the names on the tabs of the sheets.] (a) points at the first of these, and (b) at the second. -- David Biddulph "veryeavy" wrote in message ... Hi, Basic One (hopefully) What is the difference between: (a) +Return!C6 and (b) +'Return (2)'!C6? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sheet/Cell References
If you have a space(s) in the sheet name you need the single quotes around
'sheet name' If no space you don't need the single quotes. Gord Dibben MS Excel MVP On Thu, 7 Dec 2006 14:47:01 -0800, veryeavy wrote: Hi, Basic One (hopefully) What is the difference between: (a) +Return!C6 and (b) +'Return (2)'!C6? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto-increment data source cell references when copying charts | Excel Discussion (Misc queries) | |||
How to auto-increment data source cell references when copying cha | Charts and Charting in Excel | |||
Changing cell references in formulas to names and back again. | Excel Discussion (Misc queries) | |||
Cell Reference's when Pasting | Excel Discussion (Misc queries) | |||
Automatically Changing Cell Reference's when Pasting in Excel | Excel Discussion (Misc queries) |