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