+ Reply to Thread
Results 1 to 3 of 3

Copy multiple sheets including active sheet vba

  1. #1
    Registered User
    Join Date
    12-25-2015
    Location
    GREECE
    MS-Off Ver
    2007
    Posts
    31

    Copy multiple sheets including active sheet vba

    I'm trying to copy multiple sheets to new file. Everything works fine but when I try to put in the array my active sheet I get an error 9.
    I'm trying to copy the activesheet along with some others which have a standard name, but active sheet isn't always the same. I have set my activesheet to be sheetA but it doesn't work.
    my code right now is
    Please Login or Register  to view this content.
    Please help and thank you.

  2. #2
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Copy multiple sheets including active sheet vba

    Hi,

    sheetA is not the actual name of the sheet but of the variable. You must use
    Please Login or Register  to view this content.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  3. #3
    Registered User
    Join Date
    12-25-2015
    Location
    GREECE
    MS-Off Ver
    2007
    Posts
    31

    Re: Copy multiple sheets including active sheet vba

    Vba is just great and you guys are the best.
    Thank you very much. It worked of course.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Open closed workbook, copy ranges from multiple sheets into an active Mastersheet
    By bgonen in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-05-2015, 08:01 AM
  2. [SOLVED] copy multiple column, including headers, to a new sheet
    By boboivan in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-16-2015, 05:43 AM
  3. Copy same range from multiple sheets and paste into one sheet of active workbook
    By jadown in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-15-2013, 01:41 PM
  4. Copy paste multiple sheets including pivot table formats
    By Fursmanm in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-29-2012, 09:14 AM
  5. Replies: 4
    Last Post: 03-12-2012, 10:16 PM
  6. Copy cell range from active sheet to all remaining sheets
    By jpruffle in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-08-2011, 04:09 PM
  7. [SOLVED] Creating absolute references including active sheet name in the formula
    By Maria J-son in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-10-2005, 04:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1