Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
selection change macro to go down 1 cell
i need a macro that will move the cursor down 1 when certain cells are
slected. the cells are e13, e15, e17, e19, etc. when any of these r selected, i would lie the cursor to go to e14, or e 16, or e 18, etc, so the slection change is down 1. thanks... Tonso |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
selection change macro to go down 1 cell
Give this a try...
Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Column = 5 And Target.Row 12 And Target.Row Mod 2 = 1 Then Target.Offset(1).Select End If End Sub -- Rick (MVP - Excel) "Billy" wrote in message ... i need a macro that will move the cursor down 1 when certain cells are slected. the cells are e13, e15, e17, e19, etc. when any of these r selected, i would lie the cursor to go to e14, or e 16, or e 18, etc, so the slection change is down 1. thanks... Tonso |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
selection change macro to go down 1 cell
On Apr 24, 2:44*pm, "Rick Rothstein"
wrote: Give this a try... Private Sub Worksheet_SelectionChange(ByVal Target As Range) * If Target.Column = 5 And Target.Row 12 And Target.Row Mod 2 = 1 Then * * Target.Offset(1).Select * End If End Sub -- Rick (MVP - Excel) "Billy" wrote in message ... i need a macro that will move the cursor down 1 when certain cells are slected. the cells are e13, e15, e17, e19, etc. when any of these r selected, i would lie the cursor to go to e14, or e 16, or e 18, etc, so the slection change is down 1. thanks... Tonso- Hide quoted text - - Show quoted text - Rick, Thanks! Got this to working just fine! Again, many thanks, Tonso |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change from Column Selection to Cell Selection | Excel Programming | |||
run macro on selection change | Excel Programming | |||
Macro to change list box input range based on selection made in another cell | Excel Programming | |||
Selection change: How to run a Macro | Excel Programming | |||
Macro to only change selection | Excel Programming |