Office XP: runtime error '50290' Application Defined or object defined

[nkardas]

Hi,
I use a VBA add-in to write into a Excel worksheet. This add-in uses a
dll to get Real Time data from a server.
Everything works perfectly on Office 97 and office 2000.
I have an issue with OfficeXP: sometime (yes, it does not happen all
the time...), when the VBA add-in tries to write into an excel sheet,
I get the following error:
runtime error '50290' Application Defined or object defined error

The line where it breaks is:
Wb.Worksheets("Sheet1&quot.Cells(RowNbr,ColNbr).Value = myValue

myValue is an Integer, less than 100
Wb is the workbook object
RowNbr and ColNbr are Integer (their value is less than 10)


I need help. I have looked in many newsgroups but I cannot find what
is the issue. I have a deleverable on Wed this week...

Thanks.

 

[IRstuff]

Have you tried the Tek-Tips forum? There are more resources available there for this type of question

TTFN