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.
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.
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link