Finding where your applications or functions are going wrong is vital to the successful implementation of any VBA code. This tutorials shows you how you can set break points in your code and use the VBA Watch commands to see what is going wrong with your code before it does!
The tutorial also contains a great tip on how to explore the Excel Object Model using the debugging tools in VBA. This one tip can save you hours and hours of searching on line help sources for the properties you are trying to get or set.
|