maybe...

range("a1").value = range("b99").address(0,0)

See help for the .address parms

If you meant using a worksheet function:

=substitute(cell("address",b99),"$","")

David Goodall wrote:

Hi,
I'm trying to return the address of a cell in the format "A1" but the code
I'm using is returning $A$1. Is there another function I could use or could
alter the address function to output "A1"?

Thanks
David

--

Dave Peterson