SIMPLE MACRO!!!

  • Thread starter Thread starter Hugh Millen
  • Start date Start date
H

Hugh Millen

I would like to write a macro in Excel that moves the
cursor down one row, and then over to column J. I assume I
am mixing a relative reference with an absolute referance
so that moving one row down is relative, and moving over
to column J is absolute.

I tried writing a macro where I entered the "home" key
(which took me to the beginning of the row), then one
arrow key down (which obviously took me one row down), and
then the right arrow key nine times (which landed me in
column J where I wanted to be). I tried the macro in
relative and absolute mode, but the mixing of the elements
didn't work. Does anyone know how to edit the macro to do
what I want? For my use, I need to get to the cell as
quickly as possible, that's why I'm writing this macro.
Thank you very much,
Hugh Millen
 
Option Explicit
Sub moveMeFast()
With ActiveSheet
.Cells(ActiveCell.Row + 1, "J").Select
End With
End Sub

Assigning it to a shortcut key to make it work quickly?
 
Hugh - you could try creating a command button. A
simple 'GoTo' command button can be created using the
following syntax:

Private Sub CommandButton1_Click()
Application.Goto Reference:=Worksheets("Sheet1").Range
("x:y"), _
Scroll:=True
End Sub

Blank Command Buttons can be sourced from the Tool Box
menu. Expand by click and drag and select 'Design Mode'
on Tool Box menu. Double click button to bring up Visual
Basic code and enter range or cell ref.
Alwyn Hunt
 
Back
Top