Trying to make a column scroll up against a split

Zzzt · Nov 29th 2005

I have a spreadsheet with about 70 columns. Picture names across the top row, and jobs, and job information in the first 5 columns. The number of hours associated with a name and a job in the middle. the page is split right after the job information. By clicking on a cell with a name, the whole page is sorted by hours. The problem is that when sorting by a name, I'd like that column to scroll left so that it is adjacent to the split. Any ideas?

Dave Hawley · Nov 30th 2005

Re: Trying to make a column scroll up against a split

Hi Zzzt

Welcome to ozgrid

Could you upload a small relative example?

acw · Nov 30th 2005

Re: Trying to make a column scroll up against a split

HI

If you can identify the column number that contains the name (presumably you can as you are sorting by it) then try something like

Code

activewindow.scrollcolumn = ??

where ?? is the relevant number. This should put the column next to the split.

Tony

Zzzt · Dec 5th 2005

Re: Trying to make a column scroll up against a split

ActiveWindow.ScrollColumn worked! Thanks!

Trying to make a column scroll up against a split

Participate now!

Share