Auto-Scroll when Column Number Selected

[foustus82]

I have a project plan that breaks out each week of the year as a column. I have a data validation list at the top that allows me to select which week I want to highlight. So, if I pick "Week 3", it will highlight the column of the roadmap that corresponds to Week 3. For dates later in the year, I'd like to have this also scroll to that column. So, if I selected "Week 32", not only will Excel highlight that column (which I already have working), but also for Excel to scroll over to the column it just highlighted.

Any ideas?

 

[Joe4]

If you just select any cell in that column, it should jump right to it, i.e.

    Cells(1, 32).Select

Can you incorporate that into your current code?
If you need help, please post the code that you currently have.