vba select cell with same value as another cell

[bluefeather8989]

I need a macro to select the value in sheets (Score F6:F51) that matches the same number from sheets (Scoreboard AA10).

 

[jolivanes]

MsgBox Sheets("Sheet1").Range("F6:F51").Find(Sheets("Sheet2").Range("AA10"), , , 1).Address

 

[bluefeather8989]

MsgBox Sheets("Sheet1").Range("F6:F51").Find(Sheets("Sheet2").Range("AA10"), , , 1).Address

I'm sorry it was very late when i wrote this but i need it to select the cell not the address. can you plz rewrite this?

 

[MARK858]

Application.Goto Sheets("Sheet1").Range("F6:F51").Find(Sheets("Sheet2").Range("AA10"), Sheets("Sheet1").Range("F51"), , 1), True

Please note it will error if the search term isn't in the range

 

[bluefeather8989]

Application.Goto Sheets("Sheet1").Range("F6:F51").Find(Sheets("Sheet2").Range("AA10"), Sheets("Sheet1").Range("F51"), , 1), True

Please note it will error if the search term isn't in the range

For futre referenc this code will only work if Sheets("Sheet1") is selected. I had to add Sheets("Sheet1").Select code above this code. It works fine for me.

 

[MARK858]

For futre referenc this code will only work if Sheets("Sheet1") is selected. I had to add Sheets("Sheet1").Select code above this code. It works fine for me.

The sheet does NOT need selecting for that code (it needs no selecting of the sheet or the cell, it goes there as is), if are using Select then the sheet does need activating/selecting so just

Sheets("Sheet1").Activate
Range("F6:F51").Find(Sheets("Sheet2").Range("AA10"), Range("F51"), , 1).Select