IT guy needs help to answer Find & Replace question

[Desktop Works]

Hi everyone,

I apologize if this is a nubie question.

I have a user that when doing a Find & Replace, it doesn't find, even though the text is clearly in two fields (very simple sheet). The same spreadsheet on my PC finds the two results perfectly.

I've checked her Find & Replace settings, they are right, so maybe this is more of an Excel macro issue?

Thanks in advance for any advice you can give.

Johnathon

 

[VoG]

Click the Options button. Make sure that her settings are the same as yours.

 

[Desktop Works]

Hi, thanks,

Yes, I have checked her options settings under Find & Replace, do you mean more general Excel options?

Johnathon

 

[VoG]

If she is using a macro for this, please post her code.

Excel "remembers" the settings for find and replace from the previous Find/Replace.

 

[Desktop Works]

Just double checked, no she is not using a macro, just the straight up Find & replace.

Johnathon

 

[Scott Huish]

Has a selection (more than one cell) been made or is there only one cell selected?

 

[Desktop Works]

Lol, user swears that only single cell was selected, however, it is now working!

So unless this is intermittent you have solved it.

Thank you! You and this forum rock...

Johnathon