Macro reference to a specific cell on a different worksheet
 

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

Macro reference to a specific cell on a different worksheet
 

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

If this post helps click Yes
---------------
Jacob Skaria


"Nickis" wrote:

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

Macro reference to a specific cell on a different worksheet
 

Thank You!

"Jacob Skaria" wrote:

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

If this post helps click Yes
---------------
Jacob Skaria


"Nickis" wrote:

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