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

--
Drrott
-----------------------------------------------------------------------
Drrott1's Profile: http://www.excelforum.com/member.php...fo&userid=1546
View this thread: http://www.excelforum.com/showthread.php?threadid=27048