This works

Worksheets("sheet1").Range("b17:o17").Copy _
Destination:=Worksheets("Week " & WeekSheet).Cells(NextRow, "F")

But I only want to copy the values not the formats. So how do I change the
above to paste just the values?

Hi Pete

See how I use resize in this example on this page and use use the value property
http://www.rondebruin.nl/copy1.htm#range1



--
Regards Ron de Bruin
http://www.rondebruin.nl



"Pete" wrote in message ...
This works

Worksheets("sheet1").Range("b17:o17").Copy _
Destination:=Worksheets("Week " & WeekSheet).Cells(NextRow, "F")

But I only want to copy the values not the formats. So how do I change the
above to paste just the values?