INSERT ROWS between ROWS

Hi! Good morning all!

I have a sheet with many values!

Eg.

A

1
2
3
4
5
6
7
8
9
10

I would like to INSERT a row between each rows

Desired result:

A

1

2

3

4

5

6

7

8

9

10


Appreciate your early reply!

Hi Kjxavier,

In the attached sheet is a solution with VBA, just run the macro "insert row". Cell "A1" should have a heading.

Assuming you have column header in A1, values start from A2 and you want to insert first blank row in A3 i.e. below the first value in column A in A2, then try this.....

Please Login or Register  to view this content.

If you want blank row to start from just below the column header, change the number 3 in the red with 2 in the above code.
For detail see the attached sheet.