Selection Delete

I have a situation where I have data in three columns. I have empty cells that I want to be able to delete for printing purposes. I am using the following code to remove the blank cells but the method I am using is not efficent. (I am having to issue the selection.delete command multiple times to be able to delete all the empty cells.) It works but at the same time it is very inefficent. Any suggestions would be greatly appreciated.

Please Login or Register  to view this content.

Thanks,

Met

That only clears part of the data. I have to basically repeat the command multiple times to clear all the data. (Not sure why?)

Thanks anyway.