Q200527 "How to Change the Colors ..." - TYPE MISMATCH!

J

Jack

I tried to run Microsoft's Q200527 example ("ACC2000; How
to Change the Colors of a Chart Dynamically") but it
failed with an error message (run-time error "13" - Type
Mismatch) in the following piece of code:

chtObj.Application.DataSheet. _
Cells(i + 1, j + 1).Value = _
rsRowSourceFiltered.Fields(j).Value

Has any one been able to run the above example
successfully?

Thanks.
 
Top