Search how?
Based on the value in a cell or cells?
User form?
Completely VBA driven?
And why MUST you use a macro?
I'm afraid you've given us nowhere near enough information to work
with.

Wait a minute!

(sniff sniff sniff)...is this....homework?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=381792