Selecting certain rows

I may have also misinterpreted the requirements.
If you going from B to C with not step over, change this line in to 1

For i = 2 To 20 Step 1

Hi All,

Thanks so much for the quick replies. I've played around with the responses and have been able to adapt AB33's reply to help clean up my code.

Dave