Inserting new row

S

Sure

I have several rows of data and want to insert a new row alternatively.
Suppose I have 10 rows, I want a row to be inserted so that the 2nd row
becomes 3 rd row. Then insert another row between 3rd row (2nd row
previously) and the 4th row so that the 4th row becomes the 5th row. Is it
possible to do it automatically? If so, how?
 
B

Bob Phillips

For i = Cells(Rows.Count,"A").End(xlUp).Row To 1 Step -1

Rows(i+1).Insert
Next i
 
A

Ashish Mathur

Hi,

In column B, enter 1-10 in range B1:B10. Now in B11:B20, type 1:10 again.
Now select A1:B20 and sort in ascending order on column B.

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com
 

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

Excel Help to copy information from one row at a time to another sheet 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Change Color on rows, after an IF Funtion is answered 4
Advice/best practice needed maybe some complex VB aswell 4
How can I lookup when match has more than one value? 2
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1
Selecting rows. 3
Insert Row Selection 1

Top