code to view

[robertsmyth100]

Hi,

My last question of the day. I have a command button that when pressed should jump the view to view a certain range of columns. I tried doing this by

Range(E4:E15).Activate

but it only jumps to E4 and you cannot see E10 onwards. There is enough room on the screen to view all these columns

Anyone know the code I should use to achieve this?

 

[Andrew Poulsom]

Try:

Application.GoTo Range("E4"), True

 

[VoG]

Try

Application.Goto Range("E4:E15"), True

 

[robertsmyth100]

brilliant, thanks