How do I invoke the "Reset" button in the VB Editior via code?

[Vinita]

Hi,

I am writing a macro in an MPP.The macro runs fine for the first time.But
the next time its run its popping up an Error.But again after clicking the
"Reset" button in the VB Editor the code works fine again.

Is there any way that I can "Reset" in the code itself?So that it will work
fine the next time its run.

Thanks in advance,
Vinita

 

[Doug Robbins - Word MVP]

Better to try and find out what is causing the error. Click on the Debug
button to see what line of code is highlighted when the error occurs.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Vinita]

Im getting the error "Run time error 1004 Method Cells of '_Global' failed "
at the following line of code.
Cells.Find(what:=subtask_name, lookat:=xlWhole,
earchDirection:=xlNext).Activate

 

[Vinita]

Im getting "Run time Error 1004 Method Cells of object '_Global' failed at
the following line of code.

Cells.Find(what:=subtask_name, lookat:=xlWhole,
searchDirection:=xlNext).Activate

 

[Doug Robbins - Word MVP]

I suggest that you post your question to the
microsoft.public.excel.programming newsgroup. This one is for the use of
VBA in Word and the object model for Excel is quite different.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP