Which is better?

From: Amar (anonymous_at_discussions.microsoft.com)
Date: 03/01/04 

Date: Mon, 1 Mar 2004 04:36:05 -0800

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

Relevant Pages

  • Calculation order
    ... I noted with regard to a UDF I have to convert Roman to Arabic numerals, ... What did make a difference was eliminating the Type specification (or changing ... Function Arabic (rg as variant) as long ...
    (microsoft.public.excel.programming)
  • Variant Record Sizes..
    ... I am having a hard time understanding variant records with regard to ... memory usage. ... element of the record specifies "use 16". ...
    (comp.lang.ada)
  • Re: Dynamic Data
    ... just send locale-independent textual representations of the data, ... Variant Array. ... VB6 does support Interfaces, and on the long run you ...
    (microsoft.public.vb.general.discussion)
  • Re: vt_array and JScript?
    ... Now I look at it again, maybe it was the binary data I was ... The IADs.Get and IADs.GetEx methods return a VARIANT which may, ... be a VARIANT array depending on the number of values returned by ... call the QueryInterface method on the IDispatch interface to ...
    (microsoft.public.scripting.wsh)
  • Re: vt_array and JScript?
    ... > The IADs.Get and IADs.GetEx methods return a VARIANT which may, ... a VARIANT array is returned. ... the vt member of the VARIANT ... call the QueryInterface method on the IDispatch interface to ...
    (microsoft.public.scripting.wsh)