-
I know this shouldn't be a difficult question, but on a Monday morning, I'm having major difficulties.
I am writing a macro for a spreadsheet and I can't figure out how to store the ActiveCell range (ie. B1), go do another process (ie. create a column) and go back bo the originally selected cell (ie. B1).
In theory, I want to do this:
rOrigCell = ActiveCell.<something>
Columns(ActiveCell.Column + 1).Select
Selection.Insert
ActiveCell.<something> = rOrigCell
What is the <something> that I am looking for?
HELP!!!!!
Thanks!!!
Dan
-
dim r as range
set r = activesheet.activecell
Columns(ActiveCell.Column + 1).Select
'/
'/ go off and do your stuff
'/
r.Activate '/ will make your original cell/range active.
td.
-
Thank you VERY much. It didn't like the ActiveSheet.ActiveCell, but I just assigned ActiveCell to r and all is working perfectly.
Thank you so much!!!
Dan
