CTRL + F in upward direction

T

tactps

Well-known Member

Joined

Jan 20, 2004

Messages

3,460

• Jan 31, 2007

• #2

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

 

Upvote 0

Datsmart

Well-known Member

Joined

Jun 19, 2003

Messages

7,985

• Jan 31, 2007

• #3

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

 

Upvote 0

T

tactps

Well-known Member

Joined

Jan 20, 2004

Messages

3,460

• Jan 31, 2007

• #4

Wow - great tip John!

 

Upvote 0

A

adoy73

New Member

Joined

Mar 14, 2006

Messages

46

• Feb 1, 2007

• #5

Great Thanks!

 

Upvote 0