The site formerly known as Code For Excel and Outlook
I used to think that Debug.Print statements were harmless. Up to now I was under the impression that they had no effect on performance. But after reading this thread on StackOverflow I had to test it myself. The results are a bit surprising.
Continue Reading: Testing Debug.Print Performance »
September 17, 2008 by · 
When creating a worksheet that needs to be filled in by a client/end user to collect data, you might want to require certain fields/cells to be populated. In other words, there may be certain cells like "Client Name" that need to be filled in, in order for the worksheet to be further processed (either by code or manually). We'll want to prevent end users from submitting an incomplete worksheet to us by making certain cells required.
Continue Reading: A simple debug mode for your Excel workbooks »
Site last updated: February 8, 2012
Follow Me