=Sheets(6)!G53

If the sheetname is really: Sheet 6
then: ='Sheet 6'!G53
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"cottage6" wrote:
I'm want a formula on Sheet 1 to refer back to a cell on Sheet 6, but I keep
getting an error no matter what I do. This is an example of the formula:
=Sheets(6)!G53
Can't I use a sheet name to get a value from another sheet, or am I missing
something stupid I'm doing? I do know the sheet name is correct. Thanks!