How to print the result of a VBA instruction in a separate window / test a VBA instruction without creating a new module

At any moment of your VBA program, you can test a  code line and print the result in a separate window: Use Debug.print command and make sure the immediate window is open. Note: you can also write directly your code in the immediate window as shown below:

Created by DoMyExcel.com © | Excel & VBA Consulting | Customized Excel Solutions starting at 29 USD

Services provided to Individuals and Businesses | Free Quote: DoMyExcel@gmail.com