|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 22nd, 2008, 08:31 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
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 
|
|
#2
September 22nd, 2008, 09:12 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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
|
|
#3
September 22nd, 2008, 10:10 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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
|
|
#4
September 23rd, 2008, 02:00 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
