Combining For/Next and IF/ELSE

[lukelucky]

Hi everybody,

I would have some sort of elementary question regarding VBA coding. I'd like to create a code with looping For/Next function and integrete IF/ELSE function in every loop.

Is something like that even possible?

The code below isn't working, so I'm little suspicious

Please Login or Register  to view this content.

Thank you very much for a help!

[MrShorty]

Saying that the "code below isn't working" does not tell us very much. Are you getting a compile error (you should be)? run-time error? code runs but does the wrong things? What debugging steps have you tried? Can you identify the statement that is causing the error (like from stepping through the code)?

If you are unfamiliar with debugging tools, I will refer you to this: http://www.cpearson.com/excel/DebuggingVBA.aspx

You should have a compiler error "block if without end if" or however VBA likes to phrase it. Block if help file: https://msdn.microsoft.com/en-us/lib.../gg251599.aspx

[Kaper]

For sure you are at least missing

Please Login or Register  to view this content.

before

Please Login or Register  to view this content.

Besides that the code shall work.
But ... provided swap_profile_first_column named range is where you expect.
Because you check one by one 135 cells right to the first cell of swap_profile_first_column range.

[lukelucky]

Hi guys,

thanks a lot for your responses! The break downs of macro were indeed caused by not including "END IF" into the code.

I was coming back to VBA coding after a while and apparentely forgot some elementary things But thank you again for your quick responses. You saved me a lot of time!