Type mismatch error

G

Gautam

The following statement gives an error of type mismatch in a macro
ActiveSheet.Cells(j, colcount) = (data(j, i)) / 587

where array data in a variant type

tried changing through CVar but failed


Could anyone solve this
 
G

Gautam

is data(j,i) numeric?

What are j, colcount, and i equal to (as well)?
Click to expand...

There was an error in the first part of the code which was a string, i
erased it and it worked

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

Type mismatch error 5
Project Online Timesheets Actuals Mismatches - data not publishing to projects 0
Help on setting a range 2
access visual basic program 'type mismatch' error 1
'Data Type Mismatch In Criteria Expression' error when using 'Count' in query Design; Help! 0
Search an array of sheets for an array of numbers & return count of numbers 11
Sheet(CaseName).Delete Error 13 type mismatch 0
LinEst using arrays 4

Top