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

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