"ehntd" wrote in message
...
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?

This will work for columns A through Z and for as many rows as you want:

=CHAR(64+COLUMN()) & ROW()

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm