If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Echo Back the Cell Location
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
|
|||
|
|||
Echo Back the Cell Location
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 | |
Display Modes | |
|
|
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 |