On Jun 10, 7:30 am, Gary Brown
wrote:
Dim strOriginalAddress As String

strOriginalAddress = ActiveCell.Address
'do stuff
Range(strOriginalAddress).Select

Hope this helps,
Gary Brown

"oldyork90" wrote:
NOT a vba guy... macros

I have on that does a lot of formating of a sheet. I want to return
to the cell that was active after the
formating macro is complete. I opened up the macro editor and tried
something like

a = activecell

then later on

a.activate

Thank you.

Thank you both. Works as if I paid for it. :-)