"What" argument of find only takes an exact match (as qualified by xlWhole
and xlPart).

You would need to loop through the range and make a determination on each
cell.

Or, Use an Autofilter and filter on your criteria.

Not sure what you mean by sorted descending?

After you get the list of values you want to make a list and sort it
descending?

If you used an autofilter, you could just sort the visible cells using the
built in sort functionality

--
Regards,
Tom Ogilvy


"mark kubicki" wrote in message
...
is there a function that will find an equal to or less than value (entries
will be numeric only, and sorted descending)?

similar to
Set c = Worksheets(2).Range("B1:B10").Find(What:=Qnty,
LookIn:=xlValues,
lookat:=xlWhole)

however:
xlWhole and xlPart are not appropriate arguments...

as always, thanks in advance,
-mark