Hello

Is it possible to reference a cells value to define a range reference?

     If Ans = vbYes Then
                    Sheets("INPUT").Select
                    Range("I4:M4").Select
                    Selection.Copy
                    Range("I(Worksheets("DATA").Range("ROWREF").Value)").Select
                    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
                        :=False, Transpose:=False
                    Application.CutCopyMode = False
      End If
I am trying to define the row value in the range reference with a value in a secondary cell?

Range("I(Worksheets("DATA").Range("ROWREF").Value)").Select
is this possible? and if so what am I doing wrong?

Any help would be great!

Thank you very much.