Sheet/Cell References
 

Hi,

Basic One (hopefully)

What is the difference between:

(a) +Return!C6 and
(b) +'Return (2)'!C6?

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?

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?

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?