MS Office Excel 2003 (11.5612.5606)
----
I've been using Excel more-or-less as a popular music database.
Currently, this sheet contains 25,591 rows of data. I'd routinely
used the Find funtion to locate information ... but, the function
abruptly changed its behavior in an unfavorable way.

Previously, when a search string was located, the information was
centered in the window. Now, it is found and the cell's ID is show in
the top left ... but, the row has to be scrolled to manually.

Other sheets in the workbook are not affected, the Find functions as
expected in them.

Help would be appreciated.

As ALWAYS post your code for comments


--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com
"Incarcerate Bush" <vaw2@comcast.pond> wrote in message
news:i203145uuirn8n6nnfbeoofvsb49bflg1u@4ax.com...
> MS Office Excel 2003 (11.5612.5606)
> ----
> I've been using Excel more-or-less as a popular music database.
> Currently, this sheet contains 25,591 rows of data. I'd routinely
> used the Find funtion to locate information ... but, the function
> abruptly changed its behavior in an unfavorable way.
>
> Previously, when a search string was located, the information was
> centered in the window. Now, it is found and the cell's ID is show in
> the top left ... but, the row has to be scrolled to manually.
>
> Other sheets in the workbook are not affected, the Find functions as
> expected in them.
>
> Help would be appreciated.

I don't think I've ever seen excel behave this way when I do a manual Edit|Find.

(Are you doing this manually or in code???)

But maybe you could work around it by doing a Find All and just selecting one of
the results in the bottom portion of that dialog.

Incarcerate Bush wrote:
>
> MS Office Excel 2003 (11.5612.5606)
> ----
> I've been using Excel more-or-less as a popular music database.
> Currently, this sheet contains 25,591 rows of data. I'd routinely
> used the Find funtion to locate information ... but, the function
> abruptly changed its behavior in an unfavorable way.
>
> Previously, when a search string was located, the information was
> centered in the window. Now, it is found and the cell's ID is show in
> the top left ... but, the row has to be scrolled to manually.
>
> Other sheets in the workbook are not affected, the Find functions as
> expected in them.
>
> Help would be appreciated.

--

Dave Peterson

On Fri, 25 Apr 2008 09:03:23 -0500, Dave Peterson
<petersod@verizonXSPAM.net> wrote:

>I don't think I've ever seen excel behave this way when I do a manual Edit|Find.
>
>(Are you doing this manually or in code???)
>
>But maybe you could work around it by doing a Find All and just selecting one of
>the results in the bottom portion of that dialog.

Thanks for the response. I am using the Edit/Find manual search.
I've never seen this behavior before either ... and as I said, the
other sheets in the workbook behave normally. I will try the Find
All. If that works for me I may have to get used to it. Strange,
huh?

------------------------
>
>Incarcerate Bush wrote:
>>
>> MS Office Excel 2003 (11.5612.5606)
>> ----
>> I've been using Excel more-or-less as a popular music database.
>> Currently, this sheet contains 25,591 rows of data. I'd routinely
>> used the Find funtion to locate information ... but, the function
>> abruptly changed its behavior in an unfavorable way.
>>
>> Previously, when a search string was located, the information was
>> centered in the window. Now, it is found and the cell's ID is show in
>> the top left ... but, the row has to be scrolled to manually.
>>
>> Other sheets in the workbook are not affected, the Find functions as
>> expected in them.
>>
>> Help would be appreciated.

On Fri, 25 Apr 2008 07:19:48 -0500, "Don Guillett"
<dguillett1@austin.rr.com> wrote:

>As ALWAYS post your code for comments


No code involved, using Find in immediate mode.
Thanks.

I don't think that this is the cause, but do you have frozen panes or
window|split or even multiple windows going on?

How about worksheet protection?

Any macros running?

Can you open the workbook with macros disable to test it out?

(Yeah, I don't have a guess.)

Incarcerate Bush wrote:
>
> On Fri, 25 Apr 2008 09:03:23 -0500, Dave Peterson
> <petersod@verizonXSPAM.net> wrote:
>
> >I don't think I've ever seen excel behave this way when I do a manual Edit|Find.
> >
> >(Are you doing this manually or in code???)
> >
> >But maybe you could work around it by doing a Find All and just selecting one of
> >the results in the bottom portion of that dialog.
>
> Thanks for the response. I am using the Edit/Find manual search.
> I've never seen this behavior before either ... and as I said, the
> other sheets in the workbook behave normally. I will try the Find
> All. If that works for me I may have to get used to it. Strange,
> huh?
>
> ------------------------
> >
> >Incarcerate Bush wrote:
> >>
> >> MS Office Excel 2003 (11.5612.5606)
> >> ----
> >> I've been using Excel more-or-less as a popular music database.
> >> Currently, this sheet contains 25,591 rows of data. I'd routinely
> >> used the Find funtion to locate information ... but, the function
> >> abruptly changed its behavior in an unfavorable way.
> >>
> >> Previously, when a search string was located, the information was
> >> centered in the window. Now, it is found and the cell's ID is show in
> >> the top left ... but, the row has to be scrolled to manually.
> >>
> >> Other sheets in the workbook are not affected, the Find functions as
> >> expected in them.
> >>
> >> Help would be appreciated.

--

Dave Peterson