David,

In the "Find" dialog, from the dropdown list "Look In", change "Formulas" to
"Values".

Hope this helps

Pete



"davidtips" wrote:


Hi there!

1) I noticed that the search function in MsExcel will not able to
search data that linked from other file. (example: master.xls colunm A
is linked to copy.xls colunm B)

If copy.xls A3 is XYZ, I will not able to find it by this normal search
right?
How can I perform this kind of search?

2) How can I write my code for a button to perform search?

Many thanks!

davidiew


--
davidtips
------------------------------------------------------------------------
davidtips's Profile: http://www.excelforum.com/member.php...o&userid=19103
View this thread: http://www.excelforum.com/showthread...hreadid=465900