Posted 28 April 2008 - 03:10 PM
I am new to VB and am running into trouble when trying to record a macro in Excel.
I would like to copy a column from one sheet and run the macro in multiple sheets to have it paste this information. I recorded a simple macro to illustrate:
' Macro1 Macro
' Macro recorded 4/28/2008 by PREWITRO
The problem is, when I now go to sheet 3 and run this macro, it copies the data from sheet1 and then jumps to sheet2. The data is never pasted into sheet 3.
Is there any way to write code to pick the sheet that you started running the macro from?
Any suggestions would be appreciated.