help with a macro

  • Thread starter Thread starter Stephen Larivee
  • Start date Start date
S

Stephen Larivee

I created a macro. I went into cell E1, copied the contents, and then used
the arrow key to move to the left to insert in A1. Works fine. I would
like to then go down the E column and go to another row, let's say E7, run
the macro and have it insert the contents into A7. When I do this, the
contents keep getting inserted in A1. How can I make the Pasted cell
relative to the Copied cell??

Thanks
 
Hi Stephen,

Am Thu, 8 Jul 2010 12:11:17 -0400 schrieb Stephen Larivee:
I created a macro. I went into cell E1, copied the contents, and then used
the arrow key to move to the left to insert in A1. Works fine. I would
like to then go down the E column and go to another row, let's say E7, run
the macro and have it insert the contents into A7. When I do this, the
contents keep getting inserted in A1. How can I make the Pasted cell
relative to the Copied cell??
Click to expand...

try this:
ActiveCell.Copy _
Destination:=ActiveCell.Offset(0, -4)


Regards
Claus Busch
 
Worked out great!!!! Thanks a lot.



Claus Busch said:
Hi Stephen,

Am Thu, 8 Jul 2010 12:11:17 -0400 schrieb Stephen Larivee:


try this:
ActiveCell.Copy _
Destination:=ActiveCell.Offset(0, -4)


Regards
Claus Busch
Click to expand...
 
Back
Top