With Frozen panes move to specific column based on cell value

[John_Whin]

In the below example the columns left of "L" are frozen. Beginning in L1 => CU1 have game number 1 - 82. In cell H1 is the next game number. I there a way based on the value in L1 to advance to the corresponding column?

So in this case the next game is #17 so I want first seen column right of K to be AC. (The column with 17 in cell AC1)

Thanks

 

[Fluff]

How about

Sub NextGame()
ActiveWindow.ScrollColumn = Range("H1")
End Sub

 

[John_Whin]

Slightly mis stated, I want the value in H1 to be the value that determines which column is right of "K". It would move the column with 17 (which is in cell C1) to determine which column would move to be just right of "K"

Fluff posted as I typed this

 

[John_Whin]

That returns column Q which is the 17th row beginning at A. I tried to add Range "H1"+12 but that does not work. Guess a work around might be to take the value in H1 and add 12 and put that value in another cell and use it as the base. Which does work, but it did change Calculations Options to Manual for whole workbook, so I changed it back to Automatic.

 

[Fluff]

Try

ActiveWindow.ScrollColumn = Range("H1") + 12

 

[John_Whin]

Yes, that works too and is more straight forward than my work around.

Thanks again

 

[Fluff]

You're welcome