Run Time Error 50290

[John.Greenan]

Has anyone encountered this one? Any ideas on what causes it?

Thanks in advance.

 

[Nick Hodge]

John

Perhaps a clue when this happens?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[John.Greenan]

Just referring back to the question I asked, has anyone encountered this, why
does it matter when I see it occur? If anyone else has seen it then he/she
can could reply and we can go from there...

For what it's worth, it's intermittent, typically during high volume RTD and
DDE loads in trading sheets where there are COM Addins, xlas and xlls
running. Your typical investment bank trader workstation in other words.
Never been able to replicate in a controlled fashion - wondered if anyone
else had seen it - swap stories and theories from the front line.

thanks.

 

[Nick Hodge]

John

Sorry I tried to expand the issue. Here are the only two threads discussing
this issue on MS boards

http://tinyurl.com/dpxo6

http://tinyurl.com/dlcca


Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[sebastian]

Hello - have started getting this error.
And by getting this error, I mean once every couple of seconds.

Here is the code that I am running:
Windows Scheduling procedure from
(http://www.cpearson.com/excel/ontime.htm)

every second I have a call a procedure that does the following:
Function TestProcedure()

' Install the error handler.
On Error GoTo UnexpectedError

Application.Sheets("NEATO_dash").Range("I34") = Application.
Sheets("NEATO_dash").Range("I34") + 1

If Application.Sheets("NEATO_dash").Range("I34") = 10 Then

TimeID2Kill = Application.Sheets("NEATO_dash").Range("J25")
KillTimer 0&, TimeID2Kill

End If

' Tell us what happened
UnexpectedError:
' Describe the error to the user.
MsgBox "Unexpected error" & _
Str$(Err.Number) & _
" in subroutine TestProcedure." & _
vbCrLf & _
Err.Description

End Function

when I run this for more than 1000, after a couple of minutes, the error
starts popping up....

If you can replicate this, i'd love to know.

many thanks, Sebastian.