Rob said:
I want to copy a sheet to another workbook and specify which sheet to put it before.
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,
