hi rick i need the content to be "stored " down there !!
ty for the example


"Rick Rothstein (MVP - VB)" wrote:

If you really need to shift existing content downward, then this should do
what you asked...

Range("E80:L80").Copy
Range("E82").resize(300).Insert Shift:=xlDown

However, if there is no existing data that needs to be preserved in the
target area, then you could do this instead...

Range("E80:L80").Copy Range("E82").Resize(300)

Rick


"N+" wrote in message
...
hi all !!!
i just need to write down my code so to make 300 times the next command..
or to insert 300 times a void line ( dimension e80:l80 ) in e 82 :

aWS.Range("E80:L80").Copy
aWS.Range("E82").Insert Shift:=xlDown


let me know pls if you have any idea !!
byy!