clear the immediate window?

  • Thread starter Thread starter ChasW
  • Start date Start date
C

ChasW

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

Cheers!
Chas
 
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
 
You must log in or register to reply here.

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

Today's silly question: How do I clear the immediate window? 4
How to clear the immediate window 3
Size limit to Immediate Window in Code View? 3
clearing the immediate window 3
Immediate Window? 2
Clearing Immediate Window in a debug session 2
Immed Win: how to home down and clear? 3
Clearing the Immediate Window 3

Back
Top