Chunks of Macro being skipped when running

I have a macro to insert formulas based on specific cell values. The macro run on several sheets.. The second sheet works perfectly and the first sheet works perfectly when ran to a breakpoint. When the macro is run in its entirety the first sheets does not work. If I move the variables it will work once but not again. Any advice would be appreciated.

Please Login or Register  to view this content.

The answers will come from a little skill with debugging code.

Here are a few tips.

1. Use break points to temporarily stop the process and check to see if it has done what you expected that section to do.
2. On errors, use the debug option. Inspect the variables to see what does not look right.

Dennis - Thanks for the reply. This is were I'm stuck. When I toggle breakpoints to run each part on their own. It works great. When I run the entire macro, I don't get an error message it just does not execute the macro on one of the sheets. It almost as if I could put in a breakpoint permanently in the macro it would work but would be to much of a pain to have as 2 different macros.