View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Steve Yandl Steve Yandl is offline
external usenet poster
 
Posts: 284
Default Dim an Array with a variable

Start with
Dim Maps()
and then use ReDim in your procedure once you've determined the size you
need.

Steve


"icdoo" wrote in
message ...

I need to dim a variable as an array, but I dont know how big to make it
until I found out how much information I will put in it.


.FoundFiles.Count tells me how many values I want to put in the array
but

If I try this I get an error


Dim Maps(1 To .FoundFiles.Count) As String


Is there another way?


--
icdoo
------------------------------------------------------------------------
icdoo's Profile:
http://www.excelforum.com/member.php...o&userid=27342
View this thread: http://www.excelforum.com/showthread...hreadid=501347