| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel 2010 + copy array
Hi
I have a workbook created in excel 2003 which uses Vba to copy worksheets and save them as a stand alone work workbook the code is ThisWorkbook.Worksheets(Array("sheet1")).Copy the problem is this is crashing in excel 2010 does anyone know the reason whyand what the solution is please thanks kevin |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
excel 2010 + copy array
On Monday, August 13, 2012 2:58:57 AM UTC-5, kevcar40 wrote:
Hi I have a workbook created in excel 2003 which uses Vba to copy worksheets and save them as a stand alone work workbook the code is ThisWorkbook.Worksheets(Array("sheet1")).Copy the problem is this is crashing in excel 2010 does anyone know the reason whyand what the solution is please thanks kevin Why you would have an array of ONE I don't know but your code did work in my xl2010 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
excel 2010 + copy array
On Monday, August 13, 2012 8:58:57 AM UTC+1, kevcar40 wrote:
Hi I have a workbook created in excel 2003 which uses Vba to copy worksheets and save them as a stand alone work workbook the code is ThisWorkbook.Worksheets(Array("sheet1")).Copy the problem is this is crashing in excel 2010 does anyone know the reason whyand what the solution is please thanks kevin Don Thanks for reply the reason i use array is this is the way i was taught to copy a sheet out of a workbook. if there is another method please let me know thanks kevin |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
excel 2010 + copy array
On Monday, August 13, 2012 2:58:57 AM UTC-5, kevcar40 wrote:
Hi I have a workbook created in excel 2003 which uses Vba to copy worksheets and save them as a stand alone work workbook the code is ThisWorkbook.Worksheets(Array("sheet1")).Copy the problem is this is crashing in excel 2010 does anyone know the reason whyand what the solution is please thanks kevin ThisWorkbook.Worksheets("sheet1").Copy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2010 to auto-generate an email to recipients in outlook 2010 | Excel Programming | |||
| '.Copy Destination:=' temporarily freezes multiple instances in Excel 2010 | Excel Programming | |||
| Excel 2010. How to copy chart format to all charts in sheet | Excel Programming | |||
| Excel 2010 code wont copy/paste to values | Excel Programming | |||
| Copy filename from Excel 2010 Recent Workbooks to Clipboard | Excel Discussion (Misc queries) | |||
Linear Mode
