View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pete[_23_] Pete[_23_] is offline
external usenet poster
 
Posts: 1
Default copy destination 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?