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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
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?
Click to expand...

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.
 
Back
Top