Open sheet macro with 2 variables

[JO505]

I have an Index sheet with a dropdown bix that displays a list of other sheets. Using the code below I can access any sheet shown in the dropdown cell but I want to take it one step further. I would like to open the specified sheet to the cell referenced in cell "J11". That reference is through a Vlookup an will change sepending on the data selected in the dropdown.

Please Login or Register  to view this content.

My understanding of the code is that when the sheet opens it will open to the range as specified as 'Range("A2").Select'. That being the case I need to have that range become the range as shown on the "Index" sheet,cell J11, from which the code is run. In short I need to have the range "A2" change as the selections change.

Jim O

[JO505]

Figured it out.

Please Login or Register  to view this content.

Jim O