Hi there!

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

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

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

Many thanks!

davidie

--
davidtip
-----------------------------------------------------------------------
davidtips's Profile: http://www.excelforum.com/member.php...fo&userid=1910
View this thread: http://www.excelforum.com/showthread.php?threadid=46590