For chip about scroll

  • Thread starter Thread starter GUS
  • Start date Start date
G

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
 
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
 
Back
Top