macro to move cursor one cell right
 

If I need to move the cursor to the right to paste a value copied from
another sheet , what macro command should I use

macro to move cursor one cell right
 

You don't need to. The Copy Method accepts a Range argument which
would be the destination for the paste operation.

For example:

Worksheets(1).Range("A1").Copy Destination:=Worksheets(3).Range("B12")


--JP

On Sep 22, 3:31*pm, Kodak1993
wrote:
If I need to move the cursor to the right to paste a value copied from
another sheet , what macro command should I use

macro to move cursor one cell right
 

If JP's reply does not do the trick...........

To move one cell to the right you need cellref.Offset(0, 1)


Gord Dibben MS Excel MVP

On Mon, 22 Sep 2008 12:31:01 -0700, Kodak1993
wrote:

If I need to move the cursor to the right to paste a value copied from
another sheet , what macro command should I use

macro to move cursor one cell right
 

Thanks Gord!

--JP

On Sep 22, 5:10*pm, Gord Dibben <gorddibbATshawDOTca wrote:
If JP's reply does not do the trick...........

To move one cell to the right you need * cellref.Offset(0, 1)

Gord Dibben *MS Excel MVP

On Mon, 22 Sep 2008 12:31:01 -0700, Kodak1993

wrote:
If I need to move the cursor to the right to paste a value copied from
another sheet , what macro command should I use