LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10
Default Xl search problem

Thanks Dave, I will check next time.

Rgds
Sekhar

"Dave Peterson" wrote:

Open excel (so that everything is working ok)

Then display the Edit|find (or ctrl-f) dialog, click on the options button and
make a note of all the things that are chosen.

Then the next time the Find fails, look at those options and make sure that
they're what you want.

I'm guessing that either you (or a macro) is changing one of the settings--and
excel remembers the last setting--and it "breaks" your find.

Sekhar wrote:

Hi - I am not able to search the value in xl sometimes (even if I see it
right there in front of my eyes!!), but able to do that when I save & re-open
or re-start the computer.

Any way in which I can avoid such instances?

Thanks in advance
Sekhar


--

Dave Peterson

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem with search and replace data,thanks for you help in advance. yoyo2000 Excel Discussion (Misc queries) 1 June 20th 06 03:56 AM
Vlookup: Have problem. Not taking the object that i search... SupperDuck Excel Discussion (Misc queries) 1 November 15th 05 10:02 PM
problem:search results negative in excel docs with macros spirit39 Excel Discussion (Misc queries) 0 February 10th 05 11:01 PM
Problem with search Manu Palao Excel Worksheet Functions 2 November 10th 04 05:31 PM
Problem with search anilsolipuram Excel Worksheet Functions 0 November 10th 04 04:37 PM


All times are GMT +1. The time now is 01:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"