Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dim MyArray() as Long, Dim MyArray() as String, etc.
I am using Office 2003 on Windows XP.
I am used to just dimensioning my arrays a variants (since I think at one time you had to?), but can you not now dim them as other types? Or does VBA coerce them back to variants anyway? For example: Dim arrRow() As Long Dim arrFileName() As String Is there any performance gain in doing this? Is there any other advantage in doing this? Is it considered good programming practice to do this? Any an all input appreciated. Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dim MyArray vs. Dim MyArray() | Excel Programming | |||
If Range("C1") is in MyArray | Excel Programming | |||
Can I reset an array to myarray() | Excel Programming | |||
Can I reset an array to myarray() | Excel Programming | |||
Redim MyArray | Excel Programming |