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