| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy and paste between workbooks?
Hi, I have 10 identical sheets in a workbook. I have a copy of th workbook to which i would like to paste certain non-contiguous cell from the original workbook. so i would need to loop through all 10 sheets in workbook 1 and cop certain cells to workbook 2 Can anyone give me a pointer on how to do this using VBA? Do I need to copy and paste each range seperately or can i use th union method to create the complete range of cells in each sheet that wish to copy? Thanks F -- Frigid_Digi ----------------------------------------------------------------------- Frigid_Digit's Profile: http://www.excelforum.com/member.php...fo&userid=2692 View this thread: http://www.excelforum.com/showthread.php?threadid=40188 |
| 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) | |||
| Copy and paste between workbooks | Excel Discussion (Misc queries) | |||
| Can NOT copy / paste across workbooks | Excel Discussion (Misc queries) | |||
| Can't Copy and Paste between Workbooks | Excel Discussion (Misc queries) | |||
| Copy and paste - two workbooks | Excel Programming | |||
![Frigid_Digit[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
