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.
Bookmarks