+ Reply to Thread
Results 1 to 3 of 3

Rename Sheet - Macro Error

  1. #1
    Registered User
    Join Date
    10-10-2013
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    9

    Rename Sheet - Macro Error

    For some reason, a certain part of my Rename Sheet macro keeps getting a "Compile Error". This is inconsistent - the macro works perfectly on my laptop but not on others.

    Here's a screenshot of the error. (The "Left$" is where we're having the issue)
    Macro Error.jpg

    Can anyone figure out why? Any help is appreciated!!

  2. #2
    Valued Forum Contributor xlbiznes's Avatar
    Join Date
    02-22-2013
    Location
    Bahrain
    MS-Off Ver
    Excel 2007
    Posts
    1,223

    Re: Rename Sheet - Macro Error

    It is strange that its error-ed out on Left function.
    can you try mid instead ?

    Please Login or Register  to view this content.
    Happy Computing ,

    Xlbiznes.

    To show your appreciation please click *

  3. #3
    Registered User
    Join Date
    10-10-2013
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: Rename Sheet - Macro Error

    Hi xlbiznes! Thanks for the advice.

    Turns out it was because someone used a newer version of Excel 2013 and referenced Outlook 15.0 (while I have Outlook 14.0).

+ 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. Cannot rename a sheet to same name error - Need code to override error
    By o4008 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-13-2013, 12:43 PM
  2. [SOLVED] error trapping for sheet rename
    By Xtopher in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-13-2013, 11:32 PM
  3. [SOLVED] Error message:Cannot rename a sheet to the same name as another sheet
    By AB33 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-12-2012, 11:14 AM
  4. Cannot rename a sheet error
    By yerromnitsuj in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-16-2011, 06:15 PM
  5. Object Error, Merge cells and Sheet rename.
    By JapanDave in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-26-2011, 04:39 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