Oops, forgot the 2nd negative symbol

ActiveCell.Offset(-1,-1).Value = ActiveCell.Value
ActiveCell.ClearContents

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Luke M" wrote:

You can create a relative reference using Offset

ActiveCell.Offset(-1,1).Value = ActiveCell.Value
ActiveCell.ClearContents
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Peridot" wrote:

I need to create a macro that will take the contents of a cell and move them
one column over and one cell up. The macro I made keeps putting any new move
in the same cell. It should take the contents of D3 and put them in C2, then
put the contents of D5 and put them in C4. My macro puts everything in C2, no
matter where I start. I'd appreciate anyhelp. Thanks!