still have empty cell after run Delete empty cells code

**tuongtu3** · 11-25-2012, 02:03 PM

I have to run few time to delete all empty cell if Range A5:A20 are empty. Please help me

Please Login or Register  to view this content.

Regards,
tt3

**Jakobshavn** · 11-25-2012, 02:08 PM

Go backwards:

Please Login or Register  to view this content.

**tuongtu3** · 11-25-2012, 03:55 PM

Originally Posted by Jakobshavn

Go backwards:

Please Login or Register  to view this content.

Hi Jacobshavn,
Thank you very much for your help and can you explain what does "Step -1" meaning/doing in this code?

Regards,
tt3

**Jakobshavn** · 11-25-2012, 03:58 PM

Sure..........

Please Login or Register  to view this content.

means I=1,2,3,4,...........100

Please Login or Register  to view this content.

means i=100,99,98,97...............1

**tuongtu3** · 11-25-2012, 04:28 PM

Originally Posted by Jakobshavn

Sure..........

Please Login or Register  to view this content.

means I=1,2,3,4,...........100

Please Login or Register  to view this content.

means i=100,99,98,97...............1

Hi Jakobshavn,
I understand and thank you very much for your explaination.

Regards,
tt3

Re: still have empty cell after run Delete empty cells code