Any one know how to clear Immediate Window in code?

the only way to do so it to use an addin. There are many commercial addin in the market and you can also roll your own. This is one found using google:

http://www.vb-faq.com/Articles/Fresle/addins.asp

Marco

you need to add reference to
microsoft visual basic for applications extensibility 5.3
(VBE6EXT.OLB)

Public Function ClearImmediateWindow()
On Error Resume Next
Dim winImm As VBIDE.Window
Dim winActive As VBIDE.Window
' set the Window object variable to the Current Window
144 Set winActive = VBE.ActiveWindow
' set the Window object variable to the Immediate Window
145 Set winImm = VBE.Windows("Immediate")
' Clear
146 winImm.SetFocus
147 SendKeys "^({Home})", True
148 SendKeys "^(+({End}))", True
149 SendKeys "{Del}", True
150 Debug.Print Now
151 Set winImm = Nothing
152 winActive.SetFocus
End Function