GARY wrote on 11/10/2011 :
On Nov 10, 3:29*pm, Don Guillett wrote:
On Nov 10, 2:34*pm, gary wrote:

In Excel 2007, FIND searches the cells that are AFTER the location of
the cursor.
Is there a way to search the cells that are BEFORE the cursor?

you might try selecting the column LETTER or row NUMBER then
editfind

XXXX is in C147, C149, C151 and C152
The cursor is in C153.
I type XXXX in the "Find What" box.
If I select column C, Find will locate XXXX in C147..
Is there a way to find XXXX in C152?

(I'm asking if there's a way to do a "backward" search?

Can you use VBA and 'dump' the range into a Variant so you can loop the
resulting array backwards?

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc