if you don't want the $'s, use this:


strAddress = ActiveCell.Address(0, 0)

--


Gary


"OssieMac" wrote in message
...
I think ActiveCell.Address is what you are looking for.

Example:-
Dim strAddress as String

strAddress = ActiveCell.Address

Use Replace function if you want to remove $ signs.

Regards,

OssieMac

"Jørgen Andreassen" wrote:

Hi. I want to fetch the address of the active cell so that I can use the
reference to build a formula. I have tried some, but so far I only got the
value of the active cell, and that doesn't help me at all.