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

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

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

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/

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/

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

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/