Hi All

I've been trying construct some VBA to help tidy up some text.

As an example , I have lots of blocks of text like this :

BACKSTREET BOYS
SHAPE OF MY HEART


NEW UK JIVE LONG DELETED ORIGINAL 2000
63321BX19


BACKSTREET BOYS
QUIT PLAYING GAMES
EX UK JIVE ISSUE
259807BX223

I'm trying to highlight all lines containg 'BX' , and then delete the line above each of them.

It should then look like this :

BACKSTREET BOYS
SHAPE OF MY HEART
63321BX19


BACKSTREET BOYS
QUIT PLAYING GAMES
259807BX223


Grrateful for any help