refer to a cell in another sheet

[JT]

My macro is contained in a workbook with 6 sheets (A, B,
C, D, E, and F).

I want to write an "If" statement, that looks at cell "Z1"
on sheet "A" without actualing activating Sheet "A".

Not sure how to do this. Thanks for the help......

[Bob Phillips]

If Worksheets("SheetA").Range("A1").Value = ....

--

HTH

RP
(remove nothere from the email address if mailing direct)


"JT" <anonymous@discussions.microsoft.com> wrote in message
news:05dd01c53544$78d04310$a401280a@phx.gbl...
> My macro is contained in a workbook with 6 sheets (A, B,
> C, D, E, and F).
>
> I want to write an "If" statement, that looks at cell "Z1"
> on sheet "A" without actualing activating Sheet "A".
>
> Not sure how to do this. Thanks for the help......