Deleting Empty Cells

Hello,

I'm using this nested loop to delete and right shift, empty cells. Is there a more elegant way to code this that would execute faster?

Please Login or Register  to view this content.

Thank you.

Thank you both for your help.

Much appreciated.

Vikas, your solution works well.