Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Insert Rows but not Ripple up others
Hi all,
From A100 to A200, I need to insert rows , but I do not want to push other rows below A200 down. I know code can do it, but is there a hack here? Clara thank you so much for your help |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Insert Rows but not Ripple up others
Sorry, you just missed them.
All the HACKS went to www.HacksRUs.com -- Gary Brown "clara" wrote: Hi all, From A100 to A200, I need to insert rows , but I do not want to push other rows below A200 down. I know code can do it, but is there a hack here? Clara thank you so much for your help |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Insert Rows but not Ripple up others
Hi Clara..
'----------------- From A100 to A200, I need to insert rows , but I do not want to push other rows below A200 down. I know code can do it, but is there a hack here? '----------------- I regret that I do not understand what you wish to do. If, for example, you insert a row before row 200, will row (say) 201 not automatically become row 202? --- Regards, Norman |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Insert Rows but not Ripple up others
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Insert Rows but not Ripple up others
If you want to clear the cells with code -
Sub Clear_The_Cells() Range("A100:A200").Select Selection.ClearContents End Sub -- Best wishes, Jim "clara" wrote: Hi all, From A100 to A200, I need to insert rows , but I do not want to push other rows below A200 down. I know code can do it, but is there a hack here? Clara thank you so much for your help |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Insert Rows but not Ripple up others
Hi Norman,
What I reallly want to do is to copy a range , for example A200:A300, to a range, for example B100:B200 without using range's "Select" method. Clara -- thank you so much for your help "Norman Jones" wrote: Hi Clara.. '----------------- From A100 to A200, I need to insert rows , but I do not want to push other rows below A200 down. I know code can do it, but is there a hack here? '----------------- I regret that I do not understand what you wish to do. If, for example, you insert a row before row 200, will row (say) 201 not automatically become row 202? --- Regards, Norman |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Insert Rows but not Ripple up others
Hi Clara,
Try: Range("B100::B200").Value = Range("A200::A300").Value or Range("A200::A300").Copy Destination:= Range("B100::B200"). --- Regards, Norman "clara" wrote in message ... Hi Norman, What I reallly want to do is to copy a range , for example A200:A300, to a range, for example B100:B200 without using range's "Select" method. Clara -- thank you so much for your help "Norman Jones" wrote: Hi Clara.. '----------------- From A100 to A200, I need to insert rows , but I do not want to push other rows below A200 down. I know code can do it, but is there a hack here? '----------------- I regret that I do not understand what you wish to do. If, for example, you insert a row before row 200, will row (say) 201 not automatically become row 202? --- Regards, Norman |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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 | |||
Insert page breaks every 50 rows but do not include hidden rows | Excel Programming | |||
How do i insert of spacer rows between rows in large spreadsheets | Excel Discussion (Misc queries) | |||
Copy Rows and insert these rows before a page break | Excel Programming |