Where does it leave spaces at? If you have a loop, that checks for a blank, and keep track of what row it is happening, the to highlight the row and delete it is easy (if that is what is happening)?
You code is probably a cut and paste from the other site, but you need to paste it here so we can look at what we are actually dealing with. I am not prepared to spend time to have you come back and say it doesn't work because you failed to mention that you use OLE or some stuff!
Post bask with some code, or at least let us know if we give you the code to delete a whole row, and you are keeping track of it all, would work!
It's kind of fun to do the impossible! -Walter Elias Disney