Code wont work if the first cells are empty

Hello there,

I have this code and it doesn't work when for instance its starts at row 6 but cells 6,7,8,9 are empty the code won't work and won't cycle through the rest of them.

Is there a way to fix this?

Please Login or Register  to view this content.

KJD

A For...Next rather than a Do Until...Loop perhaps?

Please Login or Register  to view this content.