Excel has a "Find Next" command but no "Find Previous" command.

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?

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

And if you're doing it manually via the Edit|find dialog, just shift-click on
the Find button.



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?

--

Dave Peterson