 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Programming / March 2008How do I invoke the "Reset" button in the VB Editior via code?
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 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.  SignatureHope 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 > Hi, > [quoted text clipped - 8 lines] > Thanks in advance, > 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 > 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. [quoted text clipped - 11 lines] > > Thanks in advance, > > 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 > 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. [quoted text clipped - 11 lines] > > Thanks in advance, > > Vinita 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. SignatureHope 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 > Im getting "Run time Error 1004 Method Cells of object '_Global' failed at > the following line of code. [quoted text clipped - 19 lines] >> > Thanks in advance, >> > Vinita
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.