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......

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

--

HTH

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


"JT" wrote in message
...
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......