How to reference another worksheet

Hi All,

I have some VBA code where I'm trying to compare values from sheet1 and sheet2. In my code for sheet1 I have tried,

If Worksheets("Sheet2").Cells(2, "B") > 3 Then....

When I try this I get an error "Subscript out of range". Is it possible what I'm trying to do?

Thanks in advance.

Try

If Worksheets("Sheet2").Cells(2, "B").Value  > 3  Then

Also - Do you have a Sheet2 in your workbook?