Pls Help Me!

  • Thread starter Thread starter davidtips
  • Start date Start date
D

davidtips

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
 
David,

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

Hope this helps

Pete
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pls Help Me! 1
formula to search and find item sheet1 copy to sheet 2 1
Pls Help Me!! 1
Pls Help Me!! 7
File Download - Security Warning 5
Do we still have...? 13
Field for End Date..Please help! 5
Pls help me ! 1

Back
Top