| Home |
| Search |
| Today's Posts |
|
#1
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
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
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
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically move cursor when cell value changes | New Users to Excel | |||
| Automatically move cursor when cell value changes | New Users to Excel | |||
| Automatically move cursor when cell value changes | New Users to Excel | |||
| Visual basic macro move cursor down 1 cell | Excel Worksheet Functions | |||
| How do I get tab to move the cursor one cell over rather than 8? | Excel Worksheet Functions | |||
Linear Mode
