Return the active cell reference in A1 notation...

[mmorancbt]

How do I, in an Excel Macro, return the reference to the Active cell?

If am on cell A1, I want it to return "A1" and if I am on J10, I want it to return "J10".

This seems straight forward but I cannot seem to "intellisense" my way through it.

Thanks

Matthew Moran

http://www.cbtoolkit.com

 

[xDone]

I think "Application.ActiveCell.Address" can do.

Raymond Tse

 

[Zathras]

That will produce "$A$1"

If you really need "A1" you can use
[tt]
ActiveCell.Address(False, False)
[/tt]

 

[mmorancbt]

Thanks folks. Right after I posted I figured it out! For some reason, when I "intellensed" I kept passing right by "address". :-o

Thanks again.

Matthew Moran

http://www.cbtoolkit.com