Declaring variables (Long, String, Integer) and interpretation spe

[Guest]

Dear Colleagues,

Does anyone know which one of the two following ways to declare a string is
faster for the VBA engine to read/interpret

1 => Dim MyVar$
1 => Dim MyVar as String

Thanks,

Mr. T

 

[Bob Phillips]

If either is actually faster, which I doubt as they are both just reserving
memory space, it will be insignificant.

What you do in the code itself will be far more important in terms of
speed/performance.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Jerry W. Lewis]

In terms of working with the variables in the body of the program, all
else being equal, I would expect that working with a specific data type
would be faster than working with a variant (which is what you get when
you don't specify a type).

It is also possible that working with Long may be faster than Integer
and Double may be faster than Single, if VBA coerces them to the longer
type for arithmetic operations and then back again.

Jerry

 

[Bob Phillips]

Jerry,

What you say is absolutely correct, but has no bearing. Dim MyVar$ and Dim
MyVar as String are both specific data types, both strings.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Jerry W. Lewis]

So much for speed reading comphrehension as I am about to walk out the
door. Ouch :-(