View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default 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......