View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave_D Dave_D is offline
external usenet poster
 
Posts: 2
Default Cell Echo Help Required

I previously sent this to the wrong newsgroup.

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.