"Find" in workbook

[Guest]

One of our Club members has a workbook with 31 sheets. He has used Merge &
Center in several locations on several sheets. When he searches (Ctrl+F)
words within the Merged cells are never found. I have easily recreated the
situation on a workbook with only three sheets. The words in the merged cells
are not found.

Any solutions?
--
Chuck Davis
Publisher/Editor
Anthem Compendium
Sun City Anthem Computer Club newsletter. Information provided on an "as is"
basis. You must evaluate its applicability to your particular situation.

 

[Frank Kabel]

Hi
easiest solution. Don't use merged cells. They just create to much
problems!

--
Regards
Frank Kabel
Frankfurt, Germany

One of our Club members has a workbook with 31 sheets. He has used Merge &
Center in several locations on several sheets. When he searches (Ctrl+F)
words within the Merged cells are never found. I have easily recreated the
situation on a workbook with only three sheets. The words in the merged cells
are not found.

Any solutions?
--
Chuck Davis
Publisher/Editor
Anthem Compendium
Sun City Anthem Computer Club newsletter. Information provided on an "as is"
basis. You must evaluate its applicability to your particular

situation.

 

[Guest]

Hi
easiest solution. Don't use merged cells. They just create to much
problems!

--
Regards
Frank Kabel
Frankfurt, Germany


situation.

Someone else have a solution?

 

[Tom Ogilvy]

Try looking in Formulas rather than values.

 

[Chuck Davis]

-----Original Message-----
Try looking in Formulas rather than values.

--
Regards,
Tom Ogilvy




.

We tried all three options.

 

[Dave Peterson]

Excel's behavior changed from xl97 (which found stuff ok, but had other issues
with merged cells).

I don't know of a work-around.

I do my best to follow Frank's suggestion.