| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to set Active Cell
Hi,
Is it possible to create a macro to get the active cell to 'jump' to a certain point in a sheet? Have tried recording the mouse scrolling down to a certain point but that doesn't seem to work. Thanks. Graham |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro to set Active Cell
Hi Graham
Try this Application.GoTo Range("H700"), True -- Regards Ron de Bruin http://www.rondebruin.nl "Graham Daniels" wrote in message ... Hi, Is it possible to create a macro to get the active cell to 'jump' to a certain point in a sheet? Have tried recording the mouse scrolling down to a certain point but that doesn't seem to work. Thanks. Graham |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro to set Active Cell
Where do you want the cell to "jump" and on what event
Manges -- Message posted from http://www.ExcelForum.com |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro to set Active Cell
I want to jump to , say A17 when the user clicks a button
Graham "mangesh_yadav " wrote in message ... Where do you want the cell to "jump" and on what event Mangesh --- Message posted from http://www.ExcelForum.com/ |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro to set Active Cell
Install this in the code option of the button
Private Sub CommandButton1_Click() Range("A17").activate End Sub "Graham Daniels" wrote in message ... I want to jump to , say A17 when the user clicks a button Graham "mangesh_yadav " wrote in message ... Where do you want the cell to "jump" and on what event Mangesh --- Message posted from http://www.ExcelForum.com/ |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro to set Active Cell
This doesn't seem to work,
Graham "Ron de Bruin" wrote in message ... Hi Graham Try this Application.GoTo Range("H700"), True -- Regards Ron de Bruin http://www.rondebruin.nl "Graham Daniels" wrote in message ... Hi, Is it possible to create a macro to get the active cell to 'jump' to a certain point in a sheet? Have tried recording the mouse scrolling down to a certain point but that doesn't seem to work. Thanks. Graham |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro to set Active Cell
Thanks to all responders, now working !
Graham "N10" wrote in message ... Install this in the code option of the button Private Sub CommandButton1_Click() Range("A17").activate End Sub "Graham Daniels" wrote in message ... I want to jump to , say A17 when the user clicks a button Graham "mangesh_yadav " wrote in message ... Where do you want the cell to "jump" and on what event Mangesh --- Message posted from http://www.ExcelForum.com/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro-active cell | Excel Discussion (Misc queries) | |||
| Active cell position for macro | Excel Worksheet Functions | |||
| how to create a macro that references the currently active cell | Excel Worksheet Functions | |||
| Run macro in active cell | Excel Programming | |||
| Run a macro in the active cell. | Excel Programming | |||
Linear Mode
