Next Without For Compile Error

[jmbosma]

Hello everyone,

I'm new to this excel forum site but have done a little bit of vba coding. My code below keeps getting a next without for compile error but I cannot figure out what is wrong. Both if statements have end ifs which is usually the reason for such an error. Any ideas on what the issue is?

Please Login or Register  to view this content.

[TMS]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here


You don't need the End If when the instruction is on the same line as the Then


Regards, TMS

[jmbosma]

Thanks for the note TMS. I started out with the code that way but it received the same error. I just removed the End ifs as seen below and am still seeing the same error. Any more ideas?

Please Login or Register  to view this content.

[MrShorty]

I don't know if it is documented anywhere, but I don't think you can have a "Next" as part of a If then statement.

When you want to conditionally perform the statements within a For..Next loop, the usual code structure I see is where one usually tests for "If test is not true, then perform steps in loop". Something like:

Please Login or Register  to view this content.