you could use the find command to find the row in a given range and then
refer to that location

for example

define tender from your form

Set rng = Range(a1:a100).Find(tender)
If rng Is Nothing Then GoTo some error default if no match
XXX=cells(rng.Row.1)


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=470110

Hi - thanks for the suggestion - I'll try that out!

Cheers


--
skuzapo
------------------------------------------------------------------------
skuzapo's Profile: http://www.excelforum.com/member.php...o&userid=27430
View this thread: http://www.excelforum.com/showthread...hreadid=470110