Thread: Location of "Find Results" on Page.

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

Is this what you need?

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

--
Don Guillett
SalesAid Software
donaldb@281.com
"E. J. Murphy" <EJMurphy@discussions.microsoft.com> wrote in message
news:BE6A0161-66B5-4A51-871B-0041B8099801@microsoft.com...
> 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

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
> donaldb@281.com
> "E. J. Murphy" <EJMurphy@discussions.microsoft.com> wrote in message
> news:BE6A0161-66B5-4A51-871B-0041B8099801@microsoft.com...
> > 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
>
>
>

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
donaldb@281.com
"E. J. Murphy" <EJMurphy@discussions.microsoft.com> wrote in message
news:FC3EF5CA-CFE1-43FF-862D-BDE0A185C6B5@microsoft.com...
> 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
> > donaldb@281.com
> > "E. J. Murphy" <EJMurphy@discussions.microsoft.com> wrote in message
> > news:BE6A0161-66B5-4A51-871B-0041B8099801@microsoft.com...
> > > 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
> >
> >
> >

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
> donaldb@281.com
> "E. J. Murphy" <EJMurphy@discussions.microsoft.com> wrote in message
> news:FC3EF5CA-CFE1-43FF-862D-BDE0A185C6B5@microsoft.com...
> > 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
> > > donaldb@281.com
> > > "E. J. Murphy" <EJMurphy@discussions.microsoft.com> wrote in message
> > > news:BE6A0161-66B5-4A51-871B-0041B8099801@microsoft.com...
> > > > 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
> > >
> > >
> > >
>
>
>

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
donaldb@281.com
"E. J. Murphy" <EJMurphy@discussions.microsoft.com> wrote in message
news:414FDDE8-CDE2-418F-97B5-927148D39DCA@microsoft.com...
> 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
> > donaldb@281.com
> > "E. J. Murphy" <EJMurphy@discussions.microsoft.com> wrote in message
> > news:FC3EF5CA-CFE1-43FF-862D-BDE0A185C6B5@microsoft.com...
> > > 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
> > > > donaldb@281.com
> > > > "E. J. Murphy" <EJMurphy@discussions.microsoft.com> wrote in message
> > > > news:BE6A0161-66B5-4A51-871B-0041B8099801@microsoft.com...
> > > > > 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
> > > >
> > > >
> > > >
> >
> >
> >