View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Joseph Tom Joseph is offline
external usenet poster
 
Posts: 51
Default How to copy Range and Paste as Values (from hidden sheet)

I am using the following to copy from a hidden sheet and paste to another
sheet.

Worksheets("Outliers_1").Cells.Copy Worksheets("Outliers").Range("A1")

I would like to paste just the values. The destination sheet is not hidden,
if that matters.
Can someone please tell me what addtional code I need to add to acomplish
this?

Thanks,

Tom