Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problems with Dr. Watson
Hi newsgroup,
when I start my macro I get an access violation from Dr. Watson and Excel is turned off - without any warning from excel itself... Does someone know why this could happen? Thanks in advance and best regards Markus |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problems with Dr. Watson
What version of Excel are you using?
One thing that cause the good doctor to appear is when you "Paste special" Excel array formulas in Excel 97 (maybe others too). If you have custom VBA formulas, they could not be working properly and wreaking havoc. The best thing to do would be to step through your macro line by line (F8) and see which line triggers Dr. Watson. I have had problems in the past especially with Application.Calculate statements and controls embedded on a worksheet (they were faulty somehow and I had to delete them and re-create them for my code to work). Jake Markus Scheible wrote: Hi newsgroup, when I start my macro I get an access violation from Dr. Watson and Excel is turned off - without any warning from excel itself... Does someone know why this could happen? Thanks in advance and best regards Markus |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i calculate a durbin-watson statistic | Excel Worksheet Functions | |||
Dr Watson is pushing my head under the poo.... | Excel Programming | |||
Dr. Watson ordinal44 error | Excel Programming | |||
Dr Watson Error on opening file with VBA | Excel Programming |