Moving to a cell from a button

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi...

I want to move to a certain cell by clicking a button, Ive used the macro
tool but it always adds the moves. I want to just jump from anywere on the
sheet to the cell by pushing the button.

heres what I have now.. but each time I push the button, it moves down 60
more rows....

Sub magneticsection()
Application.ScreenUpdating = False
ActiveWindow.SmallScroll Down:=60
Range("D76").Select
Application.ScreenUpdating = True
End Sub
 
Hi,

Sometimes macro recorder records too much...
Try this one.


Sub magneticsection()
Cells(76, 4).Select
End Sub
 
Back
Top