Improve speed of VBA code

Good Evening, I have some VBA code within an excel file which looks for empty cells and removes them, but its very slow to run, would be most grateful if someone could help point me in the right direction:

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #2 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

Hi & welcome to the board.
How about

Please Login or Register  to view this content.