lundi 20 avril 2015

Excel VBA: adding a row to a variant array in one line

I´d like to add a row to a variant array:

Dim arrMod As Variant
arrMod(numberOfRow) = Array(myValue1, myValue2, myvalue3)

The execution of this code results into an exception: Error 13: type mismatch How can I do it without iterating each column?

Thanks,

Regards

Aucun commentaire:

Enregistrer un commentaire