Problems with Dr. Watson

[Markus Scheible]

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]

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