Excell VBA question

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

[tumblingdown]

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