Look at Find and FindNext in VBA help.
In the array, just use the cell value like
ary(0) = cell.Offset(0,1).Value
ary(1) = cell.Offset(0,2).Value
--
HTH
RP
(remove nothere from the email address if mailing direct)
"kanuvas" wrote in
message ...
Hi All
i have a list of values(column a) i want to lookup from column(b) and
print out store the value in column c into an array.
EG
nme nam %
aaa aaa 1
bbb aaa 2
CCc aaa 3
ddd bbb 2
so if i lookup in name aaa, i want the aaa and 1 to be stored into an
array. Also say i had anouther column would like it to store that
value as well.
Any help would be appreciated.
--
kanuvas
------------------------------------------------------------------------
kanuvas's Profile:
http://www.excelforum.com/member.php...o&userid=27911
View this thread: http://www.excelforum.com/showthread...hreadid=483429