array in VBA
 

hi, I want to create an array which has 110 elements that have the valu
from colum E ( from E1-E110) of the workbook , How can I do it ?
Thanks in advanc

--
VC
-----------------------------------------------------------------------
VCN's Profile: http://www.excelforum.com/member.php...fo&userid=1451
View this thread: http://www.excelforum.com/showthread.php?threadid=26134

array in VBA
 

Dim vArr as Variant
vArr = Range("E1:E110").Value

this produces a 2D array

for i = 1 to 110
temp = vArr(i,1)
Next

--
Regards,
Tom Ogilvy


"VCN" wrote in message
...

hi, I want to create an array which has 110 elements that have the value
from colum E ( from E1-E110) of the workbook , How can I do it ?
Thanks in advance


--
VCN
------------------------------------------------------------------------
VCN's Profile:
http://www.excelforum.com/member.php...o&userid=14511
View this thread: http://www.excelforum.com/showthread...hreadid=261349