I am trying to make a VBA command which will take the current active cell in the current worksheet1, then "go to" worksheet2 and make the same active cell in worksheet1 active.
Ideally, be able to select any cell in Column A (select the vba command), then it would go to worksheet2 and make the previous active cell; active in worksheet2.
Thank you.
Ideally, be able to select any cell in Column A (select the vba command), then it would go to worksheet2 and make the previous active cell; active in worksheet2.
Thank you.