Insertting multiple rows

  • Thread starter Thread starter Sonnich Jensen
  • Start date Start date
S

Sonnich Jensen

I wrote about this yesterday, but I cannot find the message today...

ws.Rows(j + 1).EntireRow.Insert i - 1

Is there a waym, besides a for-loop, to insert multiple rows in one
step?

WBR
Sonnich
 
JE McGimpsey posted the following answer to your previous post:-

ws.Rows(j + 1).Resize(i - 1).Insert

regards,

OssieMac
 

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 multiple rows... 1
Insert rows in grouped sheets 2
Create file fails (StreamWriter ) 7
Inserting additional rows and only copying certain columns 1
Drawing a line for a set range 1
Error 1004: application or object defined error 4
insert blank row 6
Application-defined or object-defined error 2

Back
Top