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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Project Online Timesheets Actuals Mismatches - data not publishing to projects 0
'Data Type Mismatch In Criteria Expression' error when using 'Count' in query Design; Help! 0
type mismatch error in macro in excel 0
Change row colors based on a cell value 1
Change Color of cell 3
VBA for Dependents shortcut menu 0
Dim problems 7
Error 13 - Type Mismatch 1

Top