| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying worksheet error
Hi, I have made a macro that copies worksheets from diffrent workbooks, and then places the worksheets into the same workbook. This is a pretty simpel function, but when I have copied to many sheets I recive an error 1004. Is there an easi way to come around this ? This is in a loop: sourceWb.Worksheets("Prodject-" & year).Copy after:=thisWb.Sheets(thisWb.Worksheets.count) -- Newbie80 ------------------------------------------------------------------------ Newbie80's Profile: http://www.excelforum.com/member.php...o&userid=25946 View this thread: http://www.excelforum.com/showthread...hreadid=394664 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying worksheet, path/file access error: '\vbxxx.tmp' | Excel Discussion (Misc queries) | |||
| Error when copying worksheet | Excel Discussion (Misc queries) | |||
| Excel 2003 converted to 2007 copying worksheet error | Excel Discussion (Misc queries) | |||
| Error Copying Worksheet | Excel Worksheet Functions | |||
| Copying data to another worksheet gives "Type Mismatch" error | Excel Programming | |||
![Newbie80[_12_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
