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
 
Top