[SOLVED] deleting empty cells

NEVER MIND I FIGURED IT OUT, BUT THANKS ANYWAY.


I have data with empty cells throughout in a column. My goal is to erase the empty cells in the column with the data without disturbing the other columns and end up with no empty cells in between each piece of data. The problem is that the sub routine bellow is deleting all the cells including the ones with the data.

Please Login or Register  to view this content.

Hi Truss123, perhaps the following?

Please Login or Register  to view this content.