undo

[next]

How come undo isn't available after a macro was ran? Is there a way to step back? Getting tired here of closing and reopening the same book just to test blocks of code.
:think:

[Jan Karel Pieterse]

No way back I'm afraid, unless you use the methods described here:
www.jkp-ads.com/articles/undowithvba00.asp (http://www.jkp-ads.com/articles/undowithvba00.asp)

What I usually do when debugging is copy the range I'm working on to somewhere safe so I can paste it back.