On May 11, 6:55 pm, Joel wrote:
the statement was not giving me an error. Tried a couple of ways of ways to
get errror 13. the only way I found of getting error 13 was to declare data
as a string
Dim data(10,10) as string.

Check the declaration of the array data.



"Gautam" wrote:
When i try the following statement in a macro, i get an error 13, Type
mismatch. Could anyone solve this please
ActiveSheet.Cells(j, colcount) = (data(j, i)) / 587

array data is declared as variant

Thanks- Hide quoted text -

- Show quoted text -

Thanks Joel
The first part of the array was indeed a string