Steven,

Manually - Ctrl-A in the immediate window and then delete

Auto - get a copy of MZ-Tools a free VBE add-in.

--

HTH

RP

"Steven Deng" wrote in message
news:Ej0hd.70976$nl.47494@pd7tw3no...
Hello,

I tried a couple methods posted on the internet, yet to find a working
one.
If you have something working, can you share? Thank you!

Sincerely,
Steven Deng