Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert Rows
Hi All,
I have several sheets in my work book. If I insert a row say row 10 in sheet3 I want to get a new inserted at row 10 in my sheet5, sheet7 and sheet8. Is there a way to do this with VBA ? TIA soniya |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert Rows
Hi again ,
and I forget to mention to copy the formula from the aboe row at the same time..? say i f i have column a thru x then to copy formula from column C thru M thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert Rows
try to create a macro and then modify it to suit vba
Soniya wrote in message oups.com... Hi again , and I forget to mention to copy the formula from the aboe row at the same time..? say i f i have column a thru x then to copy formula from column C thru M thanks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert Rows
Hi Soniya,
Group the worksheet using following Macro: Sheets(Array("Sheet5", "Sheet7", "Sheet8")).Select Now every action performed on any group sheet will replicate to others Regards, Vinit |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
insert rows in a worksheet that do not change adjoining rows | Excel Discussion (Misc queries) | |||
How do i insert blank rows between data that is thousands of rows | Excel Discussion (Misc queries) | |||
Insert rows: Formats & formulas extended to additonal rows | Excel Worksheet Functions | |||
How do I insert blank rows between rows in completed worksheet? | Excel Discussion (Misc queries) | |||
How do i insert of spacer rows between rows in large spreadsheets | Excel Discussion (Misc queries) |