Macro reference to a specific cell on a different worksheet

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
 
J

Jacob Skaria

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

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make Macro Work On A Different PC 5
How to reference a cell from anther workbook without opening it 0
setting one worksheet cell range reference to another worksheet 1
Using a Combo Box text selection to find text on another worksheet 1
How to code macro for worksheet? 4
Macro that will insert a simple text string in top cell of text file 1
Placing TextBox text in cell 3
Using a variable to select a cell on a worksheet..."Subscript out orrange" 4

Top