| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying multiple worksheets into a new workbook
Typo:
Should be an s on both worksheets wbk2.Worksheets(wbk2.worksheets.count) -- Regards, Tom Ogilvy "Tom Ogilvy" wrote in message ... wbk2.Worksheets(wbk2.worksheet.count) would be the way to refer to the last worksheet in wbk2 another problem would be if Datasheet does not contain a valid sheetname for the activeworkbook -- Regards, Tom Ogilvy "anhjan " wrote in message ... Thanks guys for the suggestions, however, I'm still getting stuck after copying the first sheet to the new workbook. The error I get is that it is a "Runtime error '9'; Subscript is out of range" and it hightlights: Sheets(DataSheet).COPY After:=wbk2.Worksheet.Count Any other suggestions... --- Message posted from http://www.ExcelForum.com/ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying multiple cells out of multiple worksheets at same time. | Excel Discussion (Misc queries) | |||
| copying multiple worksheets to a new workbook | Excel Discussion (Misc queries) | |||
| Copying worksheets to a new workbook | Excel Discussion (Misc queries) | |||
| Copying Worksheets from 1 Workbook to another | Excel Programming | |||
| Copying worksheets to a new workbook | Excel Programming | |||
Threaded Mode
