View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
kevcar40 kevcar40 is offline
external usenet poster
 
Posts: 78
Default 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