VBA to clear the Immediate Window

Question

 

When developing a macro I often use Debug.Print to show results in the immediate window and then have to manualy delete the contents of the immediate window between executions of the macro.  Is there a VBA action to delete the contents of the immediate window? 

Answer 1

Sub stance()
Dim x As Long
For x = 1 To 10
Debug.Print x
Next

Debug.Print Now
Application.SendKeys "^g ^a {DEL}"


End Sub

---

If this answer solves your problem, please check Mark as Answered. If this answer helps, please click the Vote as Helpful button. Cheers, Rajender Saini Aditi Enterprise Solutions – Partnering Innovation | www.aditi.com

Answer 2

It's perfect. Thanks Rajendersaini.

Answer 3

very helpful. Thanks