refer to a cell in another sheet
 

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

refer to a cell in another sheet
 

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