How can I insert a row without pasting?

R

ricketts.s

I am looking for VBA code that will insert a row. However,
EntireRow.Insert seems to insert a row and then paste the clipboard
contents into the new row. Is there a VBA method that will insert a row
without this paste behavior?

Thanks,
Scott
 
D

Dave Peterson

Make sure that there's nothing in the clipboard first.

application.cutcopymode=false
somerange.entirerow.insert
 
Top