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.
by adding second stop condition like:
to both loopsPlease Login or Register to view this content.
Best Regards,
Kaper
Thanks, I was trying to put something at the bottom by Loop instead of the top. It worked fine!!
If you know the rows you are looping through why not use a For Next loop?
If posting code please use code tags, see here.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks