On May 11, 6:47 pm, wrote:
Hi
data should be an array e.g.

Dim data(1 to 10, 1 to 10) as double

Sometimes you need to pass arrays as variants (e.g. when trying to
copy an array to a range on a worksheet). Then you would do

Dim Variant_data as Variant
Variant_data = data

and you can access the numbers in Variant_data exactly as if it is an
array. But you MUST create data as an array FIRST and then make your
variant.

regards
Paul

On May 11, 2:26 pm, 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 Paul
The first part of the array was a string which popped an error
the other part of the code is fine