So that worked brilliantly, well happy, but the codes i have tried for the delete empty cells returns the error 5991, cannot access the individual rows in this collection, because the table vertically merged cells.
Is there a workaround Thanks Matt
What I'd really want is if the cell only contains "info:" then delete the/ remove the cell, this is because no answer has been returned, so therefore we dont want spaces everywhere.

Thanks Again Matt