For chip about scroll

[GUS]

If i want to scroll a particular cell beside a particular column
lets say column (c).What change do i have to make to chip macro.
I want every time i press a button the specfied cell to come next to
column c
Of course i am using <Freeze panes> at column c.
Thanks in anvance

 

[Rocky McKinley]

Hi Gus,

Try this if your trying to acheive a screen position for a particular cell.

Application.Goto Range("C10"), True
'or the same is
Range("C10").Select
ActiveWindow.ScrollColumn = 3
ActiveWindow.ScrollRow = 10

Regards, Rocky McKinley