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

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?
 
A

Alan Beban

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
 
D

Dave Peterson

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel FIND Command 4
Find cells with a space at the end 4
'Cannot insert object' message when I try to put a button on a worksheet 7
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Find and Replace Command Using Wildcard Help 1
Problem with 'Find' 5
Use Find and Replace in Excel 2
Execute a FIND on formula results 4

Top