FIND OPTION
 

Hi to all,
Is it possible that any searched cell through "control+F' should be appeared
at the first row?
Thanks in advance,
Tazeem

FIND OPTION
 

Not without using VBA and then only if there is one found cell.

If you foind 9 instances of the the value, which one should be on the first
row?

How about you use Autofilter to find the value?

That will hide all rows without the value.


Gord Dibben MS Excel MVP

On Mon, 12 Jan 2009 05:24:03 -0800, Tazeem
wrote:

Hi to all,
Is it possible that any searched cell through "control+F' should be appeared
at the first row?
Thanks in advance,
Tazeem

FIND OPTION
 

I am sorry ! I repeat my question "Is it possible that any searched cell
through (control+F or any other command) should be appeared at the top of
page or sheet?
Regards

"Tazeem" wrote:

Hi to all,
Is it possible that any searched cell through "control+F' should be appeared
at the first row?
Thanks in advance,
Tazeem

FIND OPTION
 

I didn't understand your question, but Gord answered it yesterday:

--
David Biddulph

"Tazeem" wrote in message
...
I am sorry ! I repeat my question "Is it possible that any searched cell
through (control+F or any other command) should be appeared at the top of
page or sheet?
Regards

"Tazeem" wrote:

Hi to all,
Is it possible that any searched cell through "control+F' should be
appeared
at the first row?
Thanks in advance,
Tazeem

FIND OPTION
 

Let's be generous to OP and call it a reply rather than an answer<g


Gord

On Tue, 13 Jan 2009 16:53:01 -0000, "David Biddulph" <groups [at]
biddulph.org.uk wrote:

I didn't understand your question, but Gord answered it yesterday: