| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
| Automating copy/paste/paste special when row references change | Excel Programming | |||
| help w/ generic copy & paste/paste special routine | Excel Programming | |||
| Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) | |||
| Copy and Paste macro needs to paste to a changing cell reference | Excel Programming | |||
Threaded Mode
