K Kodak1993 Sep 22, 2008 #1 If I need to move the cursor to the right to paste a value copied from another sheet , what macro command should I use
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 Sep 22, 2008 #2 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
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 Sep 22, 2008 #3 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
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
J JP Sep 23, 2008 #4 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 Click to expand...
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 Click to expand...
