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