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

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

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