Location of "Find Results" on Page.

E

E. J. Murphy

Is it possible to change the location on the page, where FIND highlights
the found cell?

In the worksheet I am searching, some of the listings can have quite a
few rows. When FIND locates and highlights the found cell, it appears in the
middle of the page. And, some of the rows are below the bottom of the visible
page.

To be more specific, can Excel be changed to have the highlighted cell
appear at the top of the page?

Thanks
 
D

Don Guillett

Is this what you need?

Sub findandscroll()
Application.Goto Range(Columns(1) _
..Find(4).Address), Scroll:=True
End Sub
 
E

E. J. Murphy

I'm not sure, Don. Where would this get entered?
I'm not writing a program, or a formula.
I want to change the way the "FIND" function displays.
 
D

Don Guillett

This is a macro that you put into a module and execute from the menu or
assign to a button.
alt f11 to goto the visual basic editor. If you like, send me an email and
I'll send you a workbook.
 
E

E. J. Murphy

OK. I understand doing this as a macro. But, I use the "FIND" continually
throughout the day. This will create more key strokes. I'm trying to reduce
the number of keystrokes/mouse clicks, that need to be performed everytime I
bring up a new find.

I brought this up here to see if anyone knows of a way to change
"REGEDIT?", to accomplish my goal.

I guess the biggest question would be, "Where does Excel get its command
to tell the screen to scroll and place the 'found' cell where it does?

Thanks, for your help, Don. If there isn't any other way, I may write the
macro to include the search and your suggested method for scrolling the page.

Thanks, again,
E. J.
 
D

Don Guillett

glad I was able to help. Your specific request is beyond me. Let me know if
you find THE solution you need.
 
Top