I have an excel sheet that I've automated for my shop ... Basically it copies a set of rows from one sheet, asks for which cell you want to start the paste at, then pastes it... Here's what I have so far:

Sub CP()
' CP Macro

Dim strReturn As String
  
strReturn = Application.InputBox(prompt:="ENTER a Single Cell Address or " & _
                        "Range(A1, F6, B12:M32, etc.)", Type:=2)
  
If strReturn = "" Then Exit Sub

    Sheets("Data").Select
    Rows("1:15").Select
    Selection.Copy
    
    Sheets("Tracker").Select
    Range(strReturn).Select
    ActiveSheet.Paste
End Sub
So I tried to use a variation of strReturn to indicate number of rows wanted but that didn't work ... Basically I'm going to create the "data" to include 50 rows, but have it selectable for the user to say they only want 5, 7 or 29 rows ... Any ideas ?

Thanks!