Clearing the Intermediate Window in VBA

Hello
Try this code

Please Login or Register  to view this content.

Or simply you can use sendkeys

Please Login or Register  to view this content.

Tried both of the previous posts. Didn't work. The "Code" one didn't clear the Intermediate
window but also caused the running VBA program to reset back to programming level as well.

The first solution as I mentioned in the original report didn't work unless there wa
s a "Stop" command between the "SendKeys" line and the "Debug.Print" command.

My solution was to put a "Stop" command into my "Debug_Print" routine. Then when I pressed
the "Jump back to the calling program" key, I ended up at the line after the call in th
e calling program.

Please Login or Register  to view this content.