try this... Note that it will not be happy if your active cell is in Column A
or on row 1 as it will be trying to acess cells that don't exist.

sub MoveStuff()
Activecell.offset(-1, -1).value = activecell.value
end sub
--
HTH...

Jim Thomlinson


"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!