Echo Back the Cell Location

#1 July 28th, 2004, 04:09 AM

Is there a VBA routine that will echo back the cell
location based on the value in another cell ? For
example, consider the following

A B C D
1 101 110.5
2 102
3 103.9
4 104
5 110.5
6 121

I'm looking for the cell location for the value (110.5)
contained in cell C1 and place the returned location (A5)
in cell D1.
I tried a few things, but I'm just getting started in
VBA. Any help would be appreciated. Also, is it possible
to do the same task with worksheet functions ?

Thanks in advance,

#2 July 28th, 2004, 05:52 AM

Hi
with worksheetfunction:
="A" & MATCH(C1,A1:A10,0)

--
Regards
Frank Kabel
Frankfurt, Germany

Davey Boy wrote:
Is there a VBA routine that will echo back the cell
location based on the value in another cell ? For
example, consider the following

A B C D
1 101 110.5
2 102
3 103.9
4 104
5 110.5
6 121

I'm looking for the cell location for the value (110.5)
contained in cell C1 and place the returned location (A5)
in cell D1.
I tried a few things, but I'm just getting started in
VBA. Any help would be appreciated. Also, is it possible
to do the same task with worksheet functions ?

Thanks in advance,

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Cloning a Cell	theDutchie	Tables	2	May 17th, 2004 01:16 PM
Do you have what it takes...	darno	Worksheet Functions	0	February 22nd, 2004 08:01 PM
Default File Location	Derek Ruesch	Setting up and Configuration	6	January 30th, 2004 03:03 AM
Conditional Formating on value of cell and prev cell	Phillips	Worksheet Functions	2	December 3rd, 2003 11:27 PM
Convert a Cell Reference to Text	Chuck Buker	Worksheet Functions	6	September 22nd, 2003 05:04 PM