View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
baconcow baconcow is offline
external usenet poster
 
Posts: 45
Default Difficulty with copy and paste

In the end, I could only get it to work with this code:

Set copy_range = Worksheets("Purchase Requisition") _
..Range(cell_range.Offset(cell_count, 0), cell_range.Offset(cell_count, 7))
Range("A4:H4").Copy
copy_range.Select
ActiveSheet.Paste

It seemed to want the entire range, from one end to the other, as opposed to
just the first cell I wanted to paste it to, like the Macro had.