View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
GS[_2_] GS[_2_] is offline
external usenet poster
 
Posts: 3,514
Default Save Array in memory

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