CTRL + F in upward direction

[adoy73]

I use Excel 2003. I have a list of information, and I need to do a "Find" or "CTRL + F" in the upward direction. It's hard to explain why I need it, but I do.

I know that in internet explorer and if you do a "CTRL + F" you can pick in direction up or in direction down. Is there a method of doing this in Excel?

Thanks,
Tim

 

[tactps]

You could run a macro, similar to the following:
sub FindIT()
Cells.Find(What:="v", After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _
xlPart, SearchOrder:=xlByRows, SearchDirection:=xlPrevious, MatchCase:=False _
, SearchFormat:=False).Activate
end sub

 

[Datsmart]

Hold down the shift key while clicking the "Find Next" button in the find dialog box. That will reverse the search direction.

 

[tactps]

Wow - great tip John!

 

[adoy73]

Great Thanks!