View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rick Rick is offline
external usenet poster
 
Posts: 334
Default scrolling panes to the right

Here one for you:
I have a procedure that does many things, but I want to make all of my
frozen panes to shift to the right when I do (format) all cols to autofit. I
was trying to use the following:
-- Windows(1).Panes(1).LargeScroll toRight:=-5
But it doesn't always work. Is there a better way.
Rick