I can't believe I don't know how to do this! I must be having a mental block!
I want to assign the active cell reference to a variable, then when my macro finishes, the variable's reference is made the active cell again.
For example, if F2 is my current cell, I want the variable CurCell to store the reference F2. When my macro finishes, I want the active cell to be the CurCell reference.
This code doesn't work, but this is what I'm trying to do:
Dim CurCell as Range
ActiveCell.Select
CurCell = ActiveCell.Range("A1")
....some code
....
....
Range(CurCell).Select
I can't think - what am I doing wrong?
Thanks!
Bookmarks