Thread: Copy Worksheets from one book to another?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Jonx[_5_] Jonx[_5_] is offline
external usenet poster
  
Posts: 1
Default Copy Worksheets from one book to another?
well there is an actual method for copying the worksheets. It goe
something like:

ThisApplication.ActiveWorkbook.Sheets(1).Copy( _
After:=ThisApplication.ActiveWorkbook.Sheets(3))


which will copy worksheet 1 and place it after worksheet 3 from th
same workbook. I tried playing witrh the code to copy it on differen
workbooks, and I got an error saying copy method faile

--
Message posted from http://www.ExcelForum.com

Reply With QuoteReply With Quote