Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Macro Creation
I currently have code in VB to position me to the next cell row (1) after i
reach Row 10 in any given cell. Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Row = 11 Then Target.Offset(1 - Target.Row, 1).Select End If End Sub How do I also incorporate a Ctrl+Shift+J to jump to the next cell row(1) if I want to manually do it before reaching Row 10 in any cell? Your help is much appreciated. |
#2
|
|||
|
|||
Sub Row1()
Application.Goto Cells(1, ActiveCell.Column) End Sub -- HTH RP (remove nothere from the email address if mailing direct) "Programming Cells" wrote in message ... I currently have code in VB to position me to the next cell row (1) after i reach Row 10 in any given cell. Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Row = 11 Then Target.Offset(1 - Target.Row, 1).Select End If End Sub How do I also incorporate a Ctrl+Shift+J to jump to the next cell row(1) if I want to manually do it before reaching Row 10 in any cell? Your help is much appreciated. |
#3
|
|||
|
|||
Do I have this as another Sub under my VB code in the work sheet or does this
get included in my Macro? Sorry for the questions. Sub MyMacro() ' MyMacro Macro ' Macro recorded 7/28/2005 by markl ' ' Keyboard Shortcut: Ctrl+Shift+J ' End Sub Sub Row1() Application.Goto Cells(1, ActiveCell.Column) End Sub "Bob Phillips" wrote: Sub Row1() Application.Goto Cells(1, ActiveCell.Column) End Sub -- HTH RP (remove nothere from the email address if mailing direct) "Programming Cells" wrote in message ... I currently have code in VB to position me to the next cell row (1) after i reach Row 10 in any given cell. Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Row = 11 Then Target.Offset(1 - Target.Row, 1).Select End If End Sub How do I also incorporate a Ctrl+Shift+J to jump to the next cell row(1) if I want to manually do it before reaching Row 10 in any cell? Your help is much appreciated. |
#4
|
|||
|
|||
No just put that code in myMacro.
-- HTH RP (remove nothere from the email address if mailing direct) "Programming Cells" wrote in message ... Do I have this as another Sub under my VB code in the work sheet or does this get included in my Macro? Sorry for the questions. Sub MyMacro() ' MyMacro Macro ' Macro recorded 7/28/2005 by markl ' ' Keyboard Shortcut: Ctrl+Shift+J ' End Sub Sub Row1() Application.Goto Cells(1, ActiveCell.Column) End Sub "Bob Phillips" wrote: Sub Row1() Application.Goto Cells(1, ActiveCell.Column) End Sub -- HTH RP (remove nothere from the email address if mailing direct) "Programming Cells" wrote in message ... I currently have code in VB to position me to the next cell row (1) after i reach Row 10 in any given cell. Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Row = 11 Then Target.Offset(1 - Target.Row, 1).Select End If End Sub How do I also incorporate a Ctrl+Shift+J to jump to the next cell row(1) if I want to manually do it before reaching Row 10 in any cell? Your help is much appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Make Alignment options under format cells available as shortcut | Excel Discussion (Misc queries) | |||
Help with macro looping and color query function | Excel Discussion (Misc queries) | |||
Auto number / macro creation | Excel Discussion (Misc queries) | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
Date macro | Excel Discussion (Misc queries) |