| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
next cell selection
How can I select the next cell to the right, left, up or down?
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
next cell selection
activecell.offset(i,j).select
i is the number of rows, +ve or -ve to move j is the number of columns so to select the cell to your left: activecell.offset(0,-1).select "mas" wrote: How can I select the next cell to the right, left, up or down? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
next cell selection
Hi Mas
Use the offset command Activecell.Offset(1, 0).Activate (for 1 to the right) Activecell.Offset(-1, 0).Activate (for 1 to the left) Activecell.Offset(0, -1).Activate (for 1 up) Activecell.Offset(0, 1).Activate (for 1 down) HTH Regards Aussie Bob C. "mas" wrote: How can I select the next cell to the right, left, up or down? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
next cell selection
Hi Mas
Use the offset command Activecell.Offset(1, 0).Activate (for 1 to the right) Activecell.Offset(-1, 0).Activate (for 1 to the left) Activecell.Offset(0, -1).Activate (for 1 up) Activecell.Offset(0, 1).Activate (for 1 down) HTH Regards Aussie Bob C. "mas" wrote: How can I select the next cell to the right, left, up or down? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
next cell selection
Sorry mas
Typo mistake Activecell.Offset(0, 1).Activate (for 1 to the right) Activecell.Offset(0, -1).Activate (for 1 to the left) Activecell.Offset(-1, 0).Activate (for 1 up) Activecell.Offset(1, 0).Activate (for 1 down) HTH Regards Aussie Bob C. "mas" wrote: How can I select the next cell to the right, left, up or down? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Limiting selection in a cell AND linking that selection to a list | Excel Discussion (Misc queries) | |||
| Force entry into cell, based on validation selection in adjacent cell | Excel Worksheet Functions | |||
| Copy Selection - Transpose Selection - Delete Selection | Excel Discussion (Misc queries) | |||
| Lock data in a cell a specific cell based on selection on other ce | Excel Worksheet Functions | |||
| limit cell list selection based on the selection of another list | Excel Worksheet Functions | |||
Linear Mode
