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
|