Deleting Empty Cells

[klauber]

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.

[NeedForExcel]

Try this -

Please Login or Register  to view this content.

[Vikas_Gautam]

give it a try.

Please Login or Register  to view this content.

[klauber]

Thank you both for your help.

Much appreciated.

Vikas, your solution works well.