ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   active cell - get me back there (https://www.excelbanter.com/excel-programming/412346-re-active-cell-get-me-back-there.html)

oldyork90

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. :-)


All times are GMT +1. The time now is 12:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com