| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Worksheet
Hello,
I run a macro from currWB which produces the sheet "Overview". Before I finish my macro, I need to copy this sheet into another workbook destWB. I use the following command but gettingthe error "subcript out of range". Workbooks(currWB).Sheets("Overview").Copy After:=Workbooks(destWB).Sheets. Count Any help in this regard please ...??? Sri -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200904/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy & paste cells fr open worksheet then close the worksheet | Excel Programming | |||
| Unable to Insert Worksheet/Move and copy worksheet Excel 2003 | Excel Worksheet Functions | |||
| copy range on every worksheet (diff names) to a master worksheet (to be created) | Excel Programming | |||
| copy range on every worksheet (diff names) to a master worksheet (to be created) | Excel Programming | |||
| Code to copy range vs Copy Entire Worksheet - can't figure it out | Excel Programming | |||
Threaded Mode
