Excel; Find while Autofilter is on

[SellOut]

Hello,

Is it normal that I cannot use the Find function in Excel 2000 when the autofilter is on or can I go to my boss and ask for a non-clockwork PC?

Thanks,

SO

 

[KenWright]

Can you elaborate on exactly what it doesn't find? I seem to have no problem using find on filtered data using XL2000.

Regards
Ken...........

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------

 

[xlbo]

If what you are looking for is not in the filtered list of data, it will give you a "cannot find" message but that is perfectly normal - you get the same issue if you manually hide the rows of data

Rgds, Geoff

"Having been erased. the document thjat you are seeking. Must now be retyped"

Please read FAQ222-2244 before you ask a question

 

[KenWright]

LOL - That just makes too much sense Geoff I'm sat there thinking that of course that can't be what is being attempted because why would you expect to find data in a range when you have filtered it out, so surely it must actually be there and the OP is not finding it for some reason. But of course I should have realised..........

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------

 

[xlbo]

Ken - 2 years ago I would've thought the same - some of the users here tho....sheesh !

Rgds, Geoff

"Having been erased. the document thjat you are seeking. Must now be retyped"

Please read FAQ222-2244 before you ask a question

 

[KenWright]

ROTFLMAO - Hey SellOut - Don't pay us no mind, we're just joshing

Seriously though, I think Geoff has given you your answer.

Regards
Ken...............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------

 

[SellOut]

Thanks for your help. I have got a new computer and everything seems to be working fine now which is good. I guess the old one just couldn't cope.

Cheers

SO

 

[KenWright]

LOL - I'm betting you sabotaged the machine just so you could get a new one.

Congrats on a successful strategy

Regards
Ken..........

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------