Retrieving Values

T

Todd Huttenstine

hey guys

Lets say I have data in workbook "RV.xls" worksheet "test"
Range "A3:A100". The workbook is closed and I do not want
to open it. What is the code that will make it look for
the value "TestVal23" in that sheet and if it finds it, it
then returns either True or False? And also if it finds
it, how do I make it return the cell address where it
found it?


Thanks
Todd Huttenstine
 

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

Match and Retrieve Values 0
ADO - Match and Retrieve Values 0
Word macro that can call cells out of Excel for a find and replace 0
VBA for Dependents shortcut menu 0
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3
populate a combobox based on unique values in another workbook 16
Cell values to an array, then array transpose to another workbook 8
Find the correct sheet then find a value on that sheet 8

Top