Deleting Empty Cells in a LIST

How can I delete empty cells from a LIST that I have created in a worksheet using a macro? The list ranges from "B" to "AF" and the rows will be dynamic. I want to make it so that if the entire row is empty, it should be deleted.

Hi, Try this:-

Please Login or Register  to view this content.

Regards Mick