View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rocky McKinley Rocky McKinley is offline
external usenet poster
 
Posts: 102
Default For chip about scroll

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

"GUS" wrote in message
...
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