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!

As always, post your macro for comments.

Maybe something like:

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

Regards.
Per


On 30 Sep., 16:06, 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!

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!

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!

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!