Insertrow macro

[asimsid]

Ok here's my particular situation.

I got a big worksheet, and I need to insertrows after a particular data shows up in one of the fields, say column A. This recurring data has SOME pattern to it, like AAAAA1, AAAAA2, AAAAAA3, AAAAAA4

So it's like this

AAAAAA1
Garbage info
Garbage info
Garbage info
Garbage info
AAAAAA2
Garbage info
Garbage info
AAAAAA3
Garbage info
Garbage info
Garbage info
Garbage info
Garbage info
Garbage info
Garbage info
Garbage info
AAAAAA4
Garbage info
Garbage info
Garbage info

Note there's no pattern to the number of lines I need separated. Basically before each AAAAAAx I need to insert a complete blank row. So the AAAAAAx should be the separator.

I feel I haven't explained this the best way. Let me know what you guys have understood.

end result should look like

AAAAAA1
Garbage info
Garbage info
Garbage info
Garbage info

AAAAAA2
Garbage info
Garbage info

AAAAAA3
Garbage info
Garbage info
Garbage info
Garbage info
Garbage info
Garbage info
Garbage info
Garbage info

AAAAAA4
Garbage info
Garbage info
Garbage info

[sweep]

Please Login or Register  to view this content.

[asimsid]

If it's not too much trouble can you just explain your code a little?

I'm new to making macros or knowing the ins and outs of excel altogether. If I just understood what is happening to what and where I think I might be able to play around with it.

I just copy pasted your code and it nothing happened when I ran the macro.