I have a range on my worksheet (B7:K23) that I add and remove data from via
a user form. When I clear contents of data how can I get all data below the
original data to move up a row so as I don't end up with empty cells.

Cheers
Greg