Macro to set Active Cell

[Graham Daniels]

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

 

[Ron de Bruin]

Hi Graham

Try this
Application.GoTo Range("H700"), True

 

[mangesh_yadav]

Where do you want the cell to "jump" and on what event

Manges

 

[Graham Daniels]

I want to jump to , say A17 when the user clicks a button

Graham

 

[N10]

Install this in the code option of the button

Private Sub CommandButton1_Click()
Range("A17").activate
End Sub

I want to jump to , say A17 when the user clicks a button

Graham

 

[Graham Daniels]

This doesn't seem to work,

Graham

Hi Graham

Try this
Application.GoTo Range("H700"), True

 

[Graham Daniels]

Thanks to all responders, now working !

Graham

Install this in the code option of the button

Private Sub CommandButton1_Click()
Range("A17").activate
End Sub