Any Way to Search backwards within a Workbook ?

[mstuf]

Good Morning

I use Control - F to search forward from a point within my Workbook and it looks forward for all instances of the search request.

Many of the Finds that i need to do are for Terms that there are Hundreds or even Thousands of within my Workbook.

I Sometimes Drop back a Few hundred Lines and then start my search - forward, working back up to my current row to find the most recent example of that Find Keyword. But Unless I write down every line number that comes up, when I pass that last instance of it and arrive back at my current row - I then have to go back and Search again, narrowing my range because I have passed it. ( I don't know that an example Found is the last one in the worksheet until I am past it and back at my Working Row) .

Is there a way perform a Search, BACKWARDS from where I am in my Workbook ??

Thanks MIKE

 

[parry]

No it cant work backwards. Could be done with code but it would be slower than your native find. If you select cells before you use find then Excel will only search in that area.

 

[mstuf]

Was afraid of that -- I probably isnt a feature many would use.

The Knowledge base on this board never ceases to Amaze me so i figured I might as well ask.

My application / method is kind of unique / odd the way I use it.

Thank you -

Mike

 

[GlennUK]

Once you've done your Find, close the Find dialog, and use Shift-F4 to perform Find Next, and use Ctrl-Shift-F4 to Find Previous. ( I can only tell you that this works in Excel 97 ).

 

[Richard Schollar]

Works for me in 2002!

Nice tip

Richard

 

[mstuf]

As Stated

The Knowledge base on this board never ceases to Amaze me

It works in 2000 too!

Thank You SO Much -- AGAIN

Mike

 

[MOB]

Also works in 2003

Top tip

 

[GlennUK]

Super. Thanks for checking, Parsnip and mstuf and MOB, glad it works on the new fangled versions too.

 

[parry]

Once you've done your Find, close the Find dialog, and use Shift-F4 to perform Find Next, and use Ctrl-Shift-F4 to Find Previous. ( I can only tell you that this works in Excel 97 ).

Thanks Glenn, I stand corrected.