+ Reply to Thread
Results 1 to 4 of 4

Re-naming a sheet, works but with errors

  1. #1
    Registered User
    Join Date
    09-04-2015
    Location
    Brisbane
    MS-Off Ver
    Excel 2013
    Posts
    4

    Re-naming a sheet, works but with errors

    Hi all,

    This is a part of code that changes a sheet name when copied. The name change has todays date and references a particular cell value on the original sheet. (F22) This sort of works, (Date comes across correct) but the value in cell F22 is quite a bit different. (Made up of numbers and letters)

    Sheets("Master Template").Name = Format(Now(), "dd-mm-yy" + Sheets("Master Template").Range("F22"))

    Any help is greatly appreciated.

    Cheers Bart.

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Re-naming a sheet, works but with errors

    you're a little off with the parentheses ;-)
    Please Login or Register  to view this content.
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  3. #3
    Registered User
    Join Date
    09-04-2015
    Location
    Brisbane
    MS-Off Ver
    Excel 2013
    Posts
    4

    Re: Re-naming a sheet, works but with errors

    Hey Joseph.

    Thanks buddy, works a treat. Still trying to get my head around VBA.

  4. #4
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Re-naming a sheet, works but with errors

    you're welcome :-)

+ 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. [SOLVED] Userform Login Errors - Works with One, but not the Other! *** CODING ERROR ***
    By JJFletcher in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-13-2014, 05:26 PM
  2. [SOLVED] Prevent Errors for Duplicate Tab Names When Naming Tabs Using Cell Reference
    By DeRo22 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-04-2014, 03:26 AM
  3. Data validation - works with TAB or ENTER, errors from a Mouse Click
    By Buzz83 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-15-2013, 08:38 AM
  4. Migration from Excel 2003 to Excel 2007 and chart naming code no longer works...
    By SteHawk85 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 10-05-2012, 10:14 AM
  5. [SOLVED] Works when stepped-through, but errors when macro ran
    By johnhildreth@citynet.net in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-21-2006, 09:50 PM
  6. [SOLVED] Tab-naming macro only works once :-(
    By Stilla in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-10-2006, 11:15 AM
  7. Replies: 6
    Last Post: 09-13-2005, 07:06 AM

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