| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do you move the selection one cell to the right in a macro
How do you move the selected cell in any direction from any arbitrary
position? I'm just using the VB editor. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do you move the selection one cell to the right in a macro
See the Offset command. E.g.,
ActiveCell.Offset(0, 1).Select "fder" wrote in message ... How do you move the selected cell in any direction from any arbitrary position? I'm just using the VB editor. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do you move the selection one cell to the right in a macro
ActiveCell.Offset(Row, Column).Activate EXAMPLES: to move the active cell to the right one: Activecell.Offset(0,1).Activate to move it down one: Activecell.Offset(1,0).Activate to move it left 2 and up 3: Activecell.Offset(-2,-3).Activate fder Wrote: How do you move the selected cell in any direction from any arbitrary position? I'm just using the VB editor. -- Ikaabod ------------------------------------------------------------------------ Ikaabod's Profile: http://www.excelforum.com/member.php...o&userid=33371 View this thread: http://www.excelforum.com/showthread...hreadid=541205 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do you move the selection one cell to the right in a macro
ActiveCell.Offset(Row, Column).Activate EXAMPLES: to move the active cell to the right one: Activecell.Offset(0,1).Activate to move it down one: Activecell.Offset(1,0).Activate to move it left 2 and up 3: Activecell.Offset(-2,-3).Activate fder Wrote: How do you move the selected cell in any direction from any arbitrary position? I'm just using the VB editor. -- Ikaabod ------------------------------------------------------------------------ Ikaabod's Profile: http://www.excelforum.com/member.php...o&userid=33371 View this thread: http://www.excelforum.com/showthread...hreadid=541205 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I move to the first cell in the selection in Excel 07? | Excel Worksheet Functions | |||
| Arrows move worksheet rather than cell selection, how fix? | Excel Worksheet Functions | |||
| Cell selection in a macro | Excel Programming | |||
| Newbie - Move Selection one cell to right | Excel Programming | |||
| Move selection down one cell | Excel Programming | |||
Hybrid Mode
