Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dim an Array with a variable
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dim an Array with a variable
Dim Maps
.. do the Findfile Redim Maps ( 1 To .FoundFiles.Count) -- HTH Bob Phillips (remove nothere from email address if mailing direct) "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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2D variable array | Excel Programming | |||
Array & variable | Excel Programming | |||
how can I see if an array contain a certain variable? | Excel Programming | |||
about ARRAY variable | Excel Programming | |||
Problem trying to us a range variable as an array variable | Excel Programming |