Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filling an array with integer variable
Hello, I have this small scripts, and is not working since an error occured : Expected Array! Therefore, i am wondering, can we fill an array with an integer variable ? private sub test () dim arrtemp as variant, x as integer for i=0 to 10 arrtemp(i)=x+i 'Error! next end sub Could you suggest, what to fix ? Thanks. *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filling an array with integer variable
I got a Type Mismatch error, but this worked
Dim arrtemp(0 To 10), x As Integer, i For i = 0 To 10 arrtemp(i) = x + i 'Error! Next -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Erche DP" wrote in message ... Hello, I have this small scripts, and is not working since an error occured : Expected Array! Therefore, i am wondering, can we fill an array with an integer variable ? private sub test () dim arrtemp as variant, x as integer for i=0 to 10 arrtemp(i)=x+i 'Error! next end sub Could you suggest, what to fix ? Thanks. *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filling in color in a box based upon a variable . | Excel Worksheet Functions | |||
How to specify a Range which includes an integer variable | Excel Programming | |||
Is variable an integer? | Excel Programming | |||
OutlineLevel and Integer Variable issue | Excel Programming | |||
Use of integer variable for sizing of matrix | Excel Programming |