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

"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

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

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

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

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