Do... Loop macro problem

[RSimmons]

Sorry if this code isn’t written elegantly – I am new to VBA and am learning as I go!

I’m working on a macro to clear the contents of all the cells in a certain area of the worksheet that are not locked and do not contain a hyperlink. (C7 is the first data-entry cell; EndPage1 is a specific cell near the bottom right of the sheet that sets the outside range of the cells to be cleared. This is the code so far:

Please Login or Register  to view this content.

It clears about the first 65 rows beautifully, then on the next row it gets “stuck” in the innermost do-loop and continues across the page rather than looping back to start in column A. Eventually it gets hung up and gives me an error. I can’t figure out why. Can anyone see where I’m going wrong?

Thanks!

ETA - saw the problem - see below.

[shg]

Welcome to the forum.

Unmerging all cells would be a good place to start.

[RSimmons]

Thanks!

Unfortunately I inherited this form, it's huge, and unmerging all the cells would be an undertaking on its own.

Merging was at the root of the problem, though. (I feel dumb now - I posted and 10 seconds later saw the problem. This after 2 hours of heartburn.) I had to change it to "Loop Until CCounter > CMax" ( > rather than = ). Doh.