Posted to microsoft.public.excel.programming

mrt

external usenet poster

Posts: 70

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

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Declaring Variables	matt_steer[_2_]	Excel Programming	2	May 17th 04 09:53 PM
DEclaring variables	Pedro	Excel Programming	1	November 13th 03 05:02 PM
Declaring variables	Pedro	Excel Programming	1	November 13th 03 03:32 PM
DEclaring variables	Pedro	Excel Programming	2	November 13th 03 11:54 AM
Declaring Variables	chris brunt	Excel Programming	2	August 4th 03 02:02 PM

All times are GMT +1. The time now is 12:27 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us