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?
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" <[email protected]> wrote in message news:[email protected]...
> 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?
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks