What's in the criteria area, and what is some sample data that you
expect would be returned for that criteria?

jjfjr wrote:
I've done some more inspection on the behavior of the macro and it seems to
be always returning the first row of the "Data" sheet no matter what criteria
I put in.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html