Type mismatch error

  • Thread starter Thread starter Gautam
  • Start date Start date
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
 
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
 
Back
Top