View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
moon[_7_] moon[_7_] is offline
external usenet poster
 
Posts: 53
Default Moving to a cell from a button

Hi,

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


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



"JT" schreef in bericht
...
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
--
Thanks JT