Thanks for the suggestion but that wont work for what im trying to atchieve!

Any other help gladly recieved!!!

"Roger Govier" wrote:

Hi Paul

in VBA yes, you can use
activecell.address
activecell.row
activecell.column

as a Worksheet formula
=ROW() will return the row number of the cell in which you type the
formula
=COLUMN() will return the column number

In a formula, I think you might be needing the Offset() function as
=CELL("address",C7), will return $C$7 but in that case, you have fed it
the location, so therefore you know the address.
=CELL("address"OFFSET(A1,2,6) will also return $C$7

can you give an example of what you are trying to achieve?

--
Regards

Roger Govier


"PaulW" wrote in message
...
Is there a formula that returns the address / row / column of the
active cell?

So i can use this to produce different results based on the active
cell.

PaulW