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

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

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

How to Insert Rows but not Ripple up others
 

In article ,
says...
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

It would appear that you want to clear the contents of A100:A200. If
so, select the range and press the DEL (i.e., Delete) key.

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

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

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