I tested again with your sample data in colA and my code worked same as
it did 1st time. Not sure why this isn't just a copy/paste issue for
you! You are putting the code in a standard module, right? You also
understand that when deleting rows you *must always* start at the
bottom row and work up, right?

Perhaps you can post a download link where I can look at your file and
see what details you're not telling us!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion