their are several methods that can increase the speed  of the macro....even if
u assign a Null string as VbNullstring
eg MyVar = "" better MyVar=VbNullstring

Wait for few days I'm going to publish a White Paper on this VBA perfomace and
optimization.