View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Jorgen Bondesen Jorgen Bondesen is offline
external usenet poster
 
Posts: 11
Default Save Array in memory

Hi Garry.

Thanks.
I will have a closer look next weekend.

--
Best Regards
Jorgen Bondesen


"GS" skrev i en meddelelse
...
Forgot to copy the declares...

Option Explicit

Public Const Delim As String = " ¿ "
Public Const hil As String = "Best regards from Joergen"
Public vaData As Variant

**Note that vaData is NOT declared as an array. This allows Excel to
automatically size it and so stepping through each row and using ReDim is
not necessary.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc