macro to move cursor one cell right

K

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
 
J

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
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Macro to automatically go to the right of the last colored cell 0
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
Moving cursor to next open cell 3
In Excel, I cannot move my cursor to another cell with arrow keys 2
moving cursor 2
moving the cursor in a macro 1
vba macro that allows insertion of symbols at cursor 0
Countif with indirect formulas needed 0

Top