How to Stop a Do While Loop at a certain row??

[jtemp57]

I need to stop my Do While loop at cell 52. Cell 53 has information that I don't want to include. My starting row is 8. I need the loop to 'do while" column A equals anything other than blank "" from row 8 through row 52, but after 52 I need it to move to my next worksheet. Here is a sample of my code:

Please Login or Register  to view this content.

[Kaper]

by adding second stop condition like:

Please Login or Register  to view this content.

to both loops

[jtemp57]

Thanks, I was trying to put something at the bottom by Loop instead of the top. It worked fine!!

[Norie]

If you know the rows you are looping through why not use a For Next loop?

[Kaper]

If you use for...next loop as suggested by Norie, you can include empty cell checking inside the loop and exit the loop if empty cell is met

Please Login or Register  to view this content.