Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I create a new table below the last one
I've been having problem creating this macro
my problem is that i have 3 sheets and I've been doing the macro jumping from one sheet to another and if I dont put my active cell in and expecify place the macro won't run and if I dont use the relative reference the macro will be repeat it in the same position on top of the one already create it , How Do I create a macro that when i make the sheet in the first sheet simultaniously create the other tables to in the other worksheets. ActiveCell.Offset(-38, 0).Range("A1").Select ActiveCell.Range("A1:O38").Select Selection.Copy ActiveCell.Offset(38, 0).Range("A1").Select ActiveSheet.Paste ActiveCell.Offset(38, 0).Range("A1").Select Sheets("T+M").Select ActiveCell.Offset(-100, -8).Range("A1").Select ActiveCell.Range("A1:W89").Select Selection.Copy ActiveSheet.Shapes("Object 29").Select ActiveCell.Offset(89, 0).Range("A1").Select ActiveSheet.Paste ActiveCell.Offset(89, 0).Range("A1").Select Sheets("Murk 12C").Select ActiveCell.Offset(-43, -8).Range("A1").Select ActiveCell.Range("A1:Q32").Select Selection.Copy ActiveCell.Offset(41, 0).Range("A1").Select ActiveSheet.Paste ActiveCell.Offset(41, 0).Range("A1").Select Sheets("MURK 11A").Select ActiveCell.Select End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Create new excel table with filtered records from another table | Excel Worksheet Functions | |||
create pivot table from excel table | Excel Worksheet Functions | |||
How do I create a pivot table if the pivot table icon or menu ite. | Charts and Charting in Excel | |||
create a source table from a special pasted value dynamic crossed table | Excel Programming |