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)


"MrT" wrote in message
...
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