View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dr. Schwartz[_2_] Dr. Schwartz[_2_] is offline
external usenet poster
 
Posts: 30
Default Copy values only

In Excel 2003 what do I need to change in this piece of code to only copy
values?

ThisWorkbook.Worksheets("source_sheet").Range(Cell s(Jour_Rw, 1),
Cells(Jour_Rw, 18)).copy
Destination:=wb.Worksheets("target-sheet").Cells(FCDB_Rw, 1)

An easy one I guess, but still...

Thanks
The Doctor