active cell - get me back there
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. :-)
|