Referencing another sheet

[cmb80]

Hi there, My data is on Sheet1. I have some code which works when I am on the same sheet, but if I am on another sheet (Sheet2) how can I adapt my code to reference Sheet 1?

Please Login or Register  to view this content.

[JieJenn]

You can specify the worksheet.

Please Login or Register  to view this content.

[cmb80]

Hi there, sorry - the bit I meant was the bit before. I want to check Column J on sheet 1 - when I am on sheet 2

Please Login or Register  to view this content.

[JieJenn]

Please Login or Register  to view this content.