excel 2010 + copy array

[kevcar40]

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 Guillett]

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

 

[kevcar40]

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

 

[Don Guillett]

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