macro to move cursor one cell right

[Kodak1993]

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

 

[JP]

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

 

[Gord Dibben]

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

 

[JP]

Thanks Gord!

--JP

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