scroll from one column to another

[gman1979]

hi guy's,

I’m trying to scroll from one column to another each time i click the "next" button.
i want the start position to always be column 8, but then each time the button clicked it scrolls to the next one up and so on, then do one that goes back the way from the current column - 1 and do on.

I’ve tried getting he column address, but keep getting error messages when i try to + or - a value to get it to descend or ascend

any help would be great guy's,

cheers

G

 

[Mike Blackman]

Hi,

How about;

Selection.EntireColumn.Offset(0, 1).Select

 

[gman1979]

that's great and if an alternative can't be found i'll use it thanks, but i'm looking for something that doesn't select the entire column (sorry if i didn’t explain that in my initial thread)

so far i've got

Private Sub Right_Click()
ActiveWindow.Panes(ActiveWindow.Panes.Count).ScrollColumn = 9
End Sub

but i want to set a start position of column 9 and then scroll + 1 from current if that's possible, i think it would look a bit slicker, ive tried setting the scrollcolumn value to a variant value that increases but i'm totally lost.

cheers

G

 

[Mike Blackman]

HI,

Well this will move it over 1 cell but stay in the same row;

Selection.Offset(0, 1).Select

Or to select the cell in row 1;

Cells(1, Selection.Offset(0, 1).Column).Select