How can I insert a row without pasting?

  • Thread starter Thread starter ricketts.s
  • Start date Start date
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
 
Make sure that there's nothing in the clipboard first.

application.cutcopymode=false
somerange.entirerow.insert
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Inserting a Copied Row inside a table 6
Excel Unable to insert cut rows into Excel online anymore? 0
Copying Row Code Doesn't Copy Conditional Formating 10
VBA - retrieve data on last create named range from previous inserted named range 0
Insert a row without taking formats from above (upper) rows or cells 6
Insert options 1
Using insert to paste a row--how done in Excel 2007 1
looking for empty row to paste a range of copied cells 1

Back
Top