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

scrolling panes to the right
 

If you know where your active cell is before you want to move to th
right, you could do an offset, instead of a scroll.

As in:
ActiveCell.offset(0,5).Activate

Not sure if that answers your question, but maybe it helps

--
DataCollecto
-----------------------------------------------------------------------
DataCollector's Profile: http://www.hightechtalks.com/m36
View this thread: http://www.hightechtalks.com/t229650