Help with row selection.

[Drrott1]

Thank you all for the help. The macro is working now. The reason I ha
the MsgBox commands was for just Debugging. the counting loop I had pu
in works great but my problem was getting the result from those loops t
copy and paste. I was able to do it with

Rows (Ftime & ":" & Stime).copy

That copied all the rows between and I was then able to move them t
another spreadsheet. I still had trouble moving it to another sheet.
was trying

Sheet("sheet2").rows(1).paste

It did not work. I did find another way to do it however.

Thanks again for all your help

Craig Schellenbac

 

[Don Guillett]

this would have worked. sheet needed the S and you needed to delete .paste
All one line or break with continuation _

Rows(ftime & ":" & stime).Copy _
Sheets("sheet2").Rows(1)

Sub copyrows()
ftime = 5
stime = 7
Rows(ftime & ":" & stime).Copy Sheets("sheet2").Rows(1)
End Sub