Results 1 to 3 of 3

Wanting to select active sheet and one other, then move to new file

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-13-2011
    Location
    Australia
    MS-Off Ver
    Office 16
    Posts
    329

    Wanting to select active sheet and one other, then move to new file

    Hi - I have the following code, but want to select the "active" sheet and the "lookups" sheet to copy and move to a new workbook.

    Because the "active sheet" name changes, it won't always be "XYZ123" hence the need for the active sheet.
    The code below is a start, but will need to be amended so it selects the "active sheet" and the "lookups sheet", and creates a New Workbook, that will solve my problem.
    thanks.

    Sub MoveSheetsNewFile()
    '
    ' MoveSheetsNewFile Macro
    '
    
    '
        Sheets(Array("XYZ123", "Lookups")).Select
        Sheets("Lookups").Activate
        Sheets(Array("XYZ123", "Lookups")).Copy
    End Sub
    Attached Files Attached Files
    Last edited by Christopherdj; 06-10-2020 at 10:11 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Move Screen to mimic active sheet
    By JimmyWilliams in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-12-2020, 09:45 PM
  2. [SOLVED] move active sheet after LastSheet
    By plans in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-04-2016, 04:48 PM
  3. (Urgent Req) VBA code required to select a sheet just before a active sheet
    By mchilapur in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-10-2015, 12:03 PM
  4. Replies: 2
    Last Post: 06-25-2013, 08:54 AM
  5. Replies: 2
    Last Post: 07-20-2012, 09:38 AM
  6. Replies: 2
    Last Post: 12-11-2008, 10:18 AM
  7. Replies: 1
    Last Post: 06-18-2005, 07:05 PM

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