Just ='Sheet 6'!G53 should do the trick

Sheet(6) is VBA syntax for referring to sheet position in the workbook.


Gord Dibben MS Excel MVP

On Fri, 2 May 2008 13:41:12 -0700, 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!