I am checking to see if the value in column B is greater than the value of Column C. If the cell is empty, then I want the macro to skip to the next cell in the loop. When I write "next i" it errors "next without for". I know there are options to use GoTo or Case Select, but I couldn't get the syntax right on that either. Any suggestions?
Please Login or Register to view this content.
Hi,
Is this what you want?
I think your error was you need a "For" for each "Next". You had two "Next" and only one "For". It is just the same as needing the same number of "(" as ")" in a formula or function.Please Login or Register to view this content.
Last edited by MarvinP; 12-05-2012 at 06:16 PM.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Okay cool. I didn't see a need to add another For. It looks like your GoTo solution is what I need. I was missing the ":" when I was trying that possibility before. I'll apply your solution tomorrow thanks.
...or
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks