Insert rows macro.
 

Hi peter

this is the sample I got:
A B
----------------------------
1 6
1 8
2 1
2 7
3 7
3 3
4 3
4 7
9 13
9 14
10 2
11 1
11 2

after run your macro, the number after 4 is not insert blank row.
A B
---------------------------
1 6
1 8

2 1
2 7

3 7
3 3

4 3
4 7

9 13
9 14
10 2
11 1
11 2

Insert rows macro.
 

Your post doesn't have any history with it. You may want to reply to the
original thread or even include what you want to happen and the macro that
failed.

Replying in the original thread is usually better.

Johnny wrote:

Hi peter

this is the sample I got:
A B
----------------------------
1 6
1 8
2 1
2 7
3 7
3 3
4 3
4 7
9 13
9 14
10 2
11 1
11 2

after run your macro, the number after 4 is not insert blank row.
A B
---------------------------
1 6
1 8

2 1
2 7

3 7
3 3

4 3
4 7

9 13
9 14
10 2
11 1
11 2

--

Dave Peterson

Insert rows macro.
 

Guys

Thx for the help. the macro that I had is working good now.

thanks
Johnny.

"Dave Peterson" wrote:

Your post doesn't have any history with it. You may want to reply to the
original thread or even include what you want to happen and the macro that
failed.

Replying in the original thread is usually better.

Johnny wrote:

Hi peter

this is the sample I got:
A B
----------------------------
1 6
1 8
2 1
2 7
3 7
3 3
4 3
4 7
9 13
9 14
10 2
11 1
11 2

after run your macro, the number after 4 is not insert blank row.
A B
---------------------------
1 6
1 8

2 1
2 7

3 7
3 3

4 3
4 7

9 13
9 14
10 2
11 1
11 2

--

Dave Peterson