Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving to a cell from a button
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving to a cell from a button
Thanks ... worked fine... been a few years since I played with excel...
-- Thanks JT "moon" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving a button on worksheet | Excel Worksheet Functions | |||
moving cells with tab button? | Excel Discussion (Misc queries) | |||
button moving | Excel Discussion (Misc queries) | |||
Command Button keeps moving! | Excel Programming | |||
Moving the Command Button | Excel Programming |