Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy a sheet
I want to copy a sheet to another workbook and specify which sheet to put it before.
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy a sheet
Rob wrote:
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 Befo=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, -- Beto Reply: Erase between the dot (inclusive) and the @. Responder: Borra la frase obvia y el punto previo. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy rows from one Data sheet to another sheet based on cell conte | Excel Discussion (Misc queries) | |||
Auto Copy/autofill Text from sheet to sheet if meets criteria | Excel Discussion (Misc queries) | |||
Search for rows in one sheet and copy into another sheet based on customer id | Excel Worksheet Functions | |||
How can i copy data from a tabbed working sheet to a summary sheet | Excel Discussion (Misc queries) | |||
relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) |