Modify existing Code.

[JO505]

I would like to modify the following code as follows. I want to have the "Range" return the value in Cell Z2 on a sheet called INDEX.

Cell Z2 returns a look up value (cell references i.e. I4, I8 etc) derived from a drop down list

Sub Open_Scoring()
'
 Open_Scoring Macro
'
    Sheets("Scoring").Visible = True
    Sheets("Scoring").Select
    Range("H3").Select
End Sub

So where in the code "Range", instead of H3 as shown, becomes the value in cell 'INDEX'!Z2.

Not sure how to write the code to say this.

Jim O

[TMS]

Untested

Sub Open_Scoring()
'
 Open_Scoring Macro
'
    Sheets("Scoring").Visible = True
    Sheets("Scoring").Select
    Range(Sheets("INDEX").Range("Z2").Value).Select
End Sub

Regards, TMS

[JO505]

Works like a charm,

Thanks much!

Jim O

[TMS]

You're welcome.