I doubt it will have any significant effect on performance - certainly much
less performance impact than looping through cells.

You actually only need a variant to pick the data up. You can write an
array of other types - however, if you pick the data up, then modify it,
then want to put it down again, there is no reason to not use a variant.

--
Regards,
Tom Ogilvy

"Amar" wrote in message
...
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)=getVariantArray

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 appreciated

Thanks and Regards,
Amar