VBA with Excel:Declaring string variable

[bushmobile]

Dim isn't a Type, it tells to VB to dimension a variable as a particular type, e.g. for a string:

Dim MyVariable As String

since you've been omitting a Type in your declarations VB has been declaring them as Variants - which are slow and use more memory, e.g.

' these are the same thing
Dim MyVariable
Dim MyVariable As Variant