Moved to the Excel Twitters archive:
Excel Twitters 20090214
Hey I made it to your Twitter list, and on my first try.
Who says VBA gives you job security must never have worked at my last employer.
And is that one of Jon Peltier's kids using Twitter? ;-)
Hey JP, we like to encourage the newcomers. ;-)
And probably Jon's kids have seen so many chart tricks that they're jaded now. A mere can can wouldn't impress them.
Why does VBA sometimes stop on breakpoints that were removed previously (even with the IDE closed and, I think, Excel restarted)?
That is due to the garbage the VBE leaves behind. Clean your code and the problem goes away:
http://www.appspro.com/Utilities/CodeCleaner.htm
Thanks, Jan Karel. I have, of course, used that fine product. I think every time I've used it, I've later discovered that bad coding, not unclean code, was the problem. But now I have something that I know Code Cleaner will cure.
Name (required)
Email (will not be published) (required)
Website
You can use these HTML tags
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>
Notify me of followup comments via e-mail. You can also subscribe without commenting.
I'm on Twitter
Subscribe by Email
Subscribe in a Reader
Copyright © 2012 Contextures Blog - All Rights ReservedPowered by WordPress & Atahualpa
Hey I made it to your Twitter list, and on my first try.
Who says VBA gives you job security must never have worked at my last employer.
And is that one of Jon Peltier's kids using Twitter? ;-)
Hey JP, we like to encourage the newcomers. ;-)
And probably Jon's kids have seen so many chart tricks that they're jaded now. A mere can can wouldn't impress them.
Why does VBA sometimes stop on breakpoints that were removed previously (even with the IDE closed and, I think, Excel restarted)?
That is due to the garbage the VBE leaves behind. Clean your code and the problem goes away:
http://www.appspro.com/Utilities/CodeCleaner.htm
Thanks, Jan Karel. I have, of course, used that fine product. I think every time I've used it, I've later discovered that bad coding, not unclean code, was the problem. But now I have something that I know Code Cleaner will cure.