View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default How to clear Immediate Window programmatically within a procedure?

Cntl A highlist the entire active worksheet. You can do the same witth

ActiveSheet.Cells.Select

You can clear the entire sheet with this

ActiveSheet.Cells.ClearContents


"joeu2004" wrote:

I know that I can clear the Immediate Window by selecting the window,
then pressing ctrl+A Delete (or ctrl+X).

Is there some way to clear the Immediate Window programmatically
within a procedure?