G Guest Jan 20, 2004 #1 I want to copy a sheet to another workbook and specify which sheet to put it before.
B Beto Jan 20, 2004 #2 Rob said: I want to copy a sheet to another workbook and specify which sheet to put it before. Click to expand... Sub Macro1() ' ' Macro1 Macro ' Macro grabada el 20-01-2004 por Beto ' ' Sheets("Hoja2").Copy Before:=Workbooks("Libro2").Sheets(3) End Sub As simple as turning on the macro recorder, perform the task, stop the macro recorder and check the resulting code. Regards,
Rob said: I want to copy a sheet to another workbook and specify which sheet to put it before. Click to expand... Sub Macro1() ' ' Macro1 Macro ' Macro grabada el 20-01-2004 por Beto ' ' Sheets("Hoja2").Copy Before:=Workbooks("Libro2").Sheets(3) End Sub As simple as turning on the macro recorder, perform the task, stop the macro recorder and check the resulting code. Regards,
