View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Patrick Molloy[_2_] Patrick Molloy[_2_] is offline
external usenet poster
 
Posts: 1,298
Default Link Cells & Paste Special Macro


Sub copystuff()
With Sheets("Sheet2")
.Range("H3:H16").Value = .Range("H3:H16").Value
.Range("H20:H33").Value = .Range("H20:H33").Value
.Range("H37:H50").Value = .Range("H37:H50").Value
End With
End Sub