Start Macro Partway Through

I like to change and edit my macros by going through them line by line by pressing F8. Whenever I change something, it makes me start at the beginning. Is there a way that I can run any line that I want to without having to start over every time I make a change?

Originally Posted by Jiptastic

I like to change and edit my macros by going through them line by line by pressing F8. Whenever I change something, it makes me start at the beginning. Is there a way that I can run any line that I want to without having to start over every time I make a change?

A debuging tips site I have found helpful is: http://www.cpearson.com/excel/debug.htm

I'm not a pro, but here is what I have done. While in debug mode, you can right click next to a statement, select "set next statement" and continue running with F8. If your code is particularly cumbersome, you may want try and simplify it by breaking into chuncks. Hope that is what you were looking for.

Thanks. That's exactly what I needed.