Debug.Print

[ExcelMonkey]

I have been usingthe Debug.Print statment to print values of variables
in the Immediate Window. Is there a command that clears the Immediate
Window?

 

[Bob Phillips]

Just click anywhere in the immediate window, Ctrl-A, and delete.

If you need VBA, this has been suggested before

Public Sub ClearImmediateWindow()
Dim MyApp As Application
Set MyApp = Application
MyApp.VBE.Windows.Item("Immediate").SetFocus
SendKeys "^a"
SendKeys "{del}"
End Sub

but I must admit I have problems with it

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)