Debug.Print

  • Thread starter Thread starter ExcelMonkey
  • Start date Start date
E

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?
 
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)
 
Back
Top