Compile error: Method or data member not found.

Trying to run the code below on a sheet but keep getting compile error. In bold is what is erroring (is that a real word?)

My aim is to have it so a box (5,2) has either a Y or N entry.
If it is Y then (9,8) = (10,31) on this page.....this works
Also if Y then another cell (9,3) = value in (1,1) from another page in this workbook (Main Data)

Where have I gone wrong??

Please Login or Register  to view this content.

Should be "Worksheets" and not "Worksheet".

omg....can't see the wood for the trees

Thanks

So now I have got past that little oversight the new code no longer gives compile errors.....but it does not return the number from Main Data cell (7,6), have I missed something else?

Please Login or Register  to view this content.

Try this.

Please Login or Register  to view this content.

Both your conditions are the same

Please Login or Register  to view this content.

I understand that both of the conditions are the same, have just added that extra elseIf and is OK now, thanks Stephen and Stepsahead