View Single Post
  #6   Report Post  
Don Guillett
 
Posts: n/a
Default Location of "Find Results" on Page.

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

--
Don Guillett
SalesAid Software

"E. J. Murphy" wrote in message
...
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.

"Don Guillett" wrote:

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.

--
Don Guillett
SalesAid Software

"E. J. Murphy" wrote in message
...
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.

"Don Guillett" wrote:

Is this what you need?

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

--
Don Guillett
SalesAid Software

"E. J. Murphy" wrote in message
...
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