excel 2010 + copy array

  • Thread starter Thread starter kevcar40
  • Start date Start date
K

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
 
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
Click to expand...

Why you would have an array of ONE I don't know but your code did work in my xl2010
 
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
Click to expand...

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
 
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
Click to expand...


ThisWorkbook.Worksheets("sheet1").Copy
 
Back
Top