In a standard module enter:

Sub tester()
Application.ScreenUpdating = False
MyRow = ActiveCell.Row
Sheets("Sheet1").Activate
Rows(MyRow).Select
Application.ScreenUpdating = True
End Sub

Create a forms button to run tester


"aehan" wrote:

Hello

I'm trying to write some code that will select the corresponding row on
another worksheet to the current row on the existing worksheet, and I'm
failing miserably. Can someone help me please.

Thankyou
Aehan