Macro reference to a specific cell on a different worksheet

  • Thread starter Thread starter Nickis
  • Start date Start date
N

Nickis

I am looking up text in a table. I have the following code that works if the
text in the active cell matches the text in A1.

How can I modify this code so that the A1 range being referenced is on a
different worksheet. I'm sure this is pretty simple, but I can't get it
right.

If ActiveCell.Text = Range("a1").Text Then
ActiveCell.Select

Thanks, Nicki
 
If ActiveCell.Text = Worksheets("Sheet1").Range("a1").Text Then
ActiveCell.Select
End If

If this post helps click Yes
 
Back
Top