VB Code to delete blank rows

Hello:

Please refer to attached file.
I need VB Code to delete blank rows if it finds in column C from Row 2 down.
Please let me know if you have any questions.
Thanks.

R

.
Here is one way :

Paste into a Routine Module, place command button on Sheet 1, connected to the macro :

Please Login or Register  to view this content.

Hello Logit:

Thanks a lot, works

R

You are welcome