Code runs but with no effect

[nteil]

Hello. I've made this code to restructure an existing excel report. If I go to the VBA editor and just press F8 all the way the code runs perfectly.
If I use ALT+F8 and click "run" then by some reason the code skips the same part of the code every time.

Please Login or Register  to view this content.

The code highlighted is the code that is skipped when I click "run" or use a button to run the code.

I've no clue why it is like that. I'm using excel 2010. The code actually worked w/o problems but suddenly when I worked with a different part of the code, those 4 lines suddenly stopped working

I even made a new macro just containing this code as well as another part of the code that fails to run at occasions. THIS code ALSO doesn't work when using "run" or when I run it using a button, but works if I press F8

Please Login or Register  to view this content.

Any feedback is appreciated also if there's suggestions to my code that could be optimized

[AB33]

You are missing some dotes with with end with

Please Login or Register  to view this content.

[Trebor76]

Looks like AB33 has provided the solution

[nteil]

Thank you for your response. I'm not sure I understand it though. As far as I can see, every 'with' statement is closed with an 'end with' statement. Are you suggesting that I shouldn't use 'with'/'end with' statement nested inside a previous 'with'/'end with' statement?

Then I'm wondering why it works when using Run Sub/Userform inside the VBA editor?

[AB33]

Then I'm wondering why it works when using Run Sub/Userform inside the VBA editor?

It is probably your cursor might be on the active sheet.

[nteil]

My mistake: It didn't work when using Run Sub/Userform. But it worked when using the 'step into F8' function.

Just moved all the nested 'with'/'end with' statements outside and now it works even when using "Run sub/Userform" - Stupid VBA Can't even handle nested with statements! properly

Thank you