This may be just simple, I read in some articles of Excel VBA that use of variants will put unnecessary overhead on execution, so it better to define every variable. but writing to a range of cells with a variant array is supposed to be fast
some thing like,
range("A1").Resize(1,17)=getVariantArra

But will this variant array affect the performance? Is looping through all the individual cells a better option

Any help in this regard will be appreciate

Thanks and Regards
Amar