Thread: Cell location
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ehntd[_14_] ehntd[_14_] is offline
external usenet poster
 
Posts: 1
Default Cell location


Hi, I am trying to build a function that returns the cell on which it i
in. For example, if I place it on A1, then it will return A1. Afte
that I want to copy and paste into the other cells and have A2, A3 an
so on. The problem is that I tried to do it with activecell and tha
does not work, since when I copy and paste the activecell is still A1.
Do you have any ideas?

Thanks

--
ehnt
-----------------------------------------------------------------------
ehntd's Profile: http://www.excelforum.com/member.php...fo&userid=1586
View this thread: http://www.excelforum.com/showthread.php?threadid=38980