Macro to insert new line after number increases

**galvinpaddy** · 11-17-2011, 04:51 PM

Hello happy campers.
I have a sheet with various information, in column A are the delivery reference numbers, some of which can appear any number of times according to how many lines the order will have.
My macro currently does

Please Login or Register  to view this content.

I would now like some code that will look through Column A (now is has been sorted A-Z) and lets say the first delivery number is 1234567891, when this number then changes to the next i would like the code to insert an empty row. (see attached)

As always, your input is much appreciated.
galvinpaddy

**JBeaucaire** · 11-17-2011, 11:37 PM

Like so:

Please Login or Register  to view this content.

**galvinpaddy** · 11-18-2011, 10:40 AM

Hello,

Thanks for your reply, when i try to run the macro i get an error

'Runt-time error '6':
Overflow

And it highlights the following line as the issue

Please Login or Register  to view this content.

Please advise

**JBeaucaire** · 11-18-2011, 12:13 PM

Please Login or Register  to view this content.

Sorry about that.

**galvinpaddy** · 11-18-2011, 12:19 PM

No need to be sry fella, your already helping me a great deal!!
Rep. added, many thanks fella.

galvinpaddy

**galvinpaddy** · 11-18-2011, 03:26 PM

please mark as solved

Thankyou

**shg** · 11-18-2011, 03:29 PM

Please take a few minutes to read the forum rules, and then you can mark it as Solved.

Thanks.

**JBeaucaire** · 11-18-2011, 10:51 PM

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

(this instruction is found as rule #9 in the Forum Rules, be sure to read through them,very helpful (and required))