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