Michael Fitzpatrick wrote:
Excel allows one to do a "Find Next" to find text in a worksheet. But there
is no "Find Previous" command. How would one implement a "Find Previous" to
find a string of text before the present cell?


To find the next previous occurrence of 4 in Column A preceding the Cell A6,

Set rng = Range("a1:a14")
Set x = rng.Find(4, Range("A6"), , , , xlPrevious)

Alan Beban