have a look here https://msdn.microsoft.com/en-us/lib.../ff839232.aspx. Using the Application.Goto function after you copy the cell in A2 may help you here.