assume the hidden sheet name is "ABCD"

then

set rng = Worksheets("ABCD").Range("A1").Value
msgbox rng.Address(external:=True) & " - value: " & rng.Value


Worksheets("ABCD").Activate
Range("A1").Select
msgbox Selection.Value

won't work.

--
Regards,
Tom Ogilvy

"Cee_Pritchard" wrote in message
...
I've written a Macro which returns information held in a sheet I now want
to
hide (I dont want anyone messing about with the data!)

But when I hide the sheet the macro can no longer find the information and
says there is a runtime error!

Any ideas how I can get it to look up the information from this hidden
sheet?

Cheers