What does Debug.Print do?

Originally Posted by royUK

This might help

Chip Pearson

Hi RoyUK,

That did indeed help me to understand the function. Thanks!

If anyone out there has the same issue as me, here is a little quote from Chip Pearson:
----------------------------------------
"You can use the Debug.Print statement anywhere in your code to display messages or variable values in the Immediate Window. These statements don't require any confirmation or acknowledgement from the user so they won't affect the operation of your code. For example, you can send a message to the Immediate Window when a particular section of code is executed.

'
' some code
'
Debug.Print "Starting Code Section 1"

The liberal use of Debug.Print statements makes it easy to track the execution of your code. Debug.Print statements have no effect on the execution of your code and so it is safe to leave them in code projects that are distributed to end users. Debug.Print statements send messages to the Immediate Window, so you should have this window open in order to see the messages.

Unfortunately, there is no way to programmatically clear the Immediate Window. This is a shortcoming that has frustrated many programmers."
----------------------------------------

NB: You can get the immediate window in VBA by pressing Ctrl+G