Adjust worksheet placement based on dropdown selected

[Terri from West Hills]

I have created validated dropdown, which in turn I have used for conditional formatting to highlight specific consecutive rows based on the dropdown.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
Is it possible for the worksheet to be positioned based on the dropdown chosen, so that the highlighted rows are visible without having to manually scroll down, looking for the highlighted rows?<o></o>
<o></o>
If dropdown chosen highlights rows 50-60, I would like the page to automatically show rows 50-60 (not necessarily hide the others, but at least scroll to rows 50-60).<o></o>

 

[tlowry]

I don't have the information to get the value from the list.

You will need to write the code for GetRowRange, or post more information.

Sub ScrollTo()
    ' you must get the value from the drop down control and put it in sRow
    sRow = GetRowRange
    ActiveWindow.ScrollRow = Mid(sRow, 1, InStr(sRow, "-") - 1)
End Sub
Function [COLOR=SeaGreen][B]GetRowRange[/B][/COLOR]()
    GetRowRange = "50-60"
End Function