I have a 1 dimension variable array which I am having problems i
accessing each entry

this is the code I have used to populate the array



dim varImpsArray

varImpsarray = wsImps.UsedRange.Value ' used range = a1 to a 62000


Is their a way of accessing each entry in the array *similar* to the
For Each cell In Range("a1:a3") that applies to spreadsheets


dim ?????? as ????
for each ?????????


I am using Excel 9

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com