ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Problems with Dr. Watson (https://www.excelbanter.com/excel-programming/321748-problems-dr-watson.html)

Markus Scheible[_2_]

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

Jakeman

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




All times are GMT +1. The time now is 10:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com