Results 1 to 8 of 8

VBA to name workbook as worksheet

Threaded View

  1. #1
    Registered User
    Join Date
    05-25-2017
    Location
    manchester, England
    MS-Off Ver
    365 Mac
    Posts
    8

    VBA to name workbook as worksheet

    Thank you for reading my post.

    I am new to VBA and I was wondering if you could advise me or guide me in the right direction.

    I have the below VBA code to copy a worksheet to a new workbook and i was wondering is there a way to add to the code to automatically rename the workbook as the worksheet name when this code is run?


    Sub Copy_Sheet_New_Workbook()
    ActiveSheet.Copy
    EndSub
    Last edited by alansidman; 05-25-2017 at 09:41 AM. Reason: code tags added

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 09-10-2016, 02:17 PM
  2. Replies: 5
    Last Post: 09-25-2015, 10:32 AM
  3. Transfer one worksheet in an excel workbook to another worksheet workbook
    By JASAMMY in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-09-2015, 02:50 PM
  4. Replies: 1
    Last Post: 07-19-2014, 06:28 AM
  5. Replies: 2
    Last Post: 07-16-2014, 12:36 PM
  6. Replies: 2
    Last Post: 05-01-2013, 06:17 AM
  7. Can't copy cells from Worksheet A in Workbook 1 to Worksheet B in Workbook 2
    By exartizo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-11-2005, 05:52 PM

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