Or just a worksheet function.

In A1:
=cell("address",a1)
or
=substitute(cell("address",a1),"$","")
(if you really don't want the $ signs.)

ehntd wrote:

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

Thanks!

--
ehntd
------------------------------------------------------------------------
ehntd's Profile: http://www.excelforum.com/member.php...o&userid=15865
View this thread: http://www.excelforum.com/showthread...hreadid=389809

--

Dave Peterson