![]() |
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