PLEASE HELP !!
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").Cells(RowNbr,ColNbr).Value = myValue
myValue is an Variant, less than 100
Wb is the workbook object RowNbr and ColNbr are Integer (their value is less than 10)
The above is a problem another member had last year that I am now getting !! Does anyone know how to resolve this issue - All feedback would be a real help - Regards Alex
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").Cells(RowNbr,ColNbr).Value = myValue
myValue is an Variant, less than 100
Wb is the workbook object RowNbr and ColNbr are Integer (their value is less than 10)
The above is a problem another member had last year that I am now getting !! Does anyone know how to resolve this issue - All feedback would be a real help - Regards Alex
