clear the immediate window?

C

ChasW

How can I programmitcally clear the VBA Immediate window before
"Debug.Print"ing a batch of data to it?

Cheers!
Chas
 
J

Jon Lewis

The only way that I am aware of is to effectively "scroll" out any text.

This I think was originaly posted by Stephen Lebans:

Dim strClear As String
strClear = String(256, vbCrLf)
Debug.Print strClear

256 I believe is an arbitrary figure which produces more than enough
carriage returns to cause any text to disappear form the Immediate window.

HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to clear the immediate window 3
Today's silly question: How do I clear the immediate window? 4
Size limit to Immediate Window in Code View? 3
Immediate Window? 2
Clearing Immediate Window in a debug session 2
clearing the immediate window 3
Immediate Window has a size limitation? 5
Cut and Paste procedure then test it in Immediate window 2

Top