Referring to Values in a seperate Worksheet
 

I need to refer to a value in a seperate worksheet and enter it in an IF
statement. What is the syntax for this?

THanks for your help.

-Chris

Referring to Values in a seperate Worksheet
 

If Worksheets("Sheet2").Range("B9").Value 3 then

--
Regards,
Tom Ogilvy


"Chris" wrote in message
...
I need to refer to a value in a seperate worksheet and enter it in an IF
statement. What is the syntax for this?

THanks for your help.

-Chris