Forum Discussion
Jon Cohen
May 21, 2021Copper Contributor
Saving a cell's address in another cell & later going back to that cell
Let's say my cursor is in cell D123. I want to create a macro that will jump to A300, save "D123" in A300, so some calculations, and then go back to cell D123. My Visual Basic skills have atrop...
- Jun 30, 2020
You do know about Ctrl+Tab / Ctrl+Shift+Tab, don't you?
Jon Cohen
May 21, 2021Copper Contributor
Thanks -- it's coming back to me. So, can I do something like...
CameFrom = ActiveCell.Address
< do my calculations, then >
ActiveCell.Address = CameFrom
?
CameFrom = ActiveCell.Address
< do my calculations, then >
ActiveCell.Address = CameFrom
?
HansVogelaar
May 21, 2021MVP
No, Address is a read-only property: you cannot set it.
You use the Select method of a cell to make it the active cell.
You could do this:
Dim CameFrom As Range
Set CameFrom = ActiveCell
...
<your calculations here>
...
CameFrom.Select
Note that CameFrom is a Range variable here, not a String variable.