How to set up a loop

I am trying to set up a macro to delete empty rows I have tryed a few things but this is the only code which seems to actully run through it.

How do I set up a loop so it will start at C20 for example and work up the sheet till C2

Please Login or Register  to view this content.

Try this code -

Please Login or Register  to view this content.

Try this.
If it works then please mark the post as SOLVED

Please Login or Register  to view this content.

Another option:

Please Login or Register  to view this content.

Nilem for some reason that will not work the first part of the macro is copying and pasting text from a table in another workbook and this seems to be making the macro think there is data in the blank cess but there is not

GrahamRoss, Did you try mine above?