+ Reply to Thread
Results 1 to 9 of 9

Rename Tabs Issue

  1. #1
    Banned User!
    Join Date
    10-12-2018
    Location
    Texas
    MS-Off Ver
    2010
    Posts
    358

    Rename Tabs Issue

    Hello,

    I am getting debug at:
    Sheets(x).Name = Worksheets(x).Range("A1").Value

    Please Login or Register  to view this content.
    This happens when I go to one of the vehicle sheets and click to put an "X" in column "O". Does anyone know why this is happening and how to fix please?

    Thank you

    Attachment removed at xjohnson's request --6SJ
    Last edited by 6StringJazzer; 01-25-2019 at 10:14 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    11-28-2015
    Location
    indo
    MS-Off Ver
    2016 64 bitt
    Posts
    1,241

    Re: Rename Tabs Issue

    perhab like this
    Please Login or Register  to view this content.
    "ThankyouFor Attention * And Your Help!!"

  3. #3
    Banned User!
    Join Date
    10-12-2018
    Location
    Texas
    MS-Off Ver
    2010
    Posts
    358

    Re: Rename Tabs Issue

    Thank you for the help but unfortunately it still goes to debug at the same line.

  4. #4
    Valued Forum Contributor
    Join Date
    11-28-2015
    Location
    indo
    MS-Off Ver
    2016 64 bitt
    Posts
    1,241
    Quote Originally Posted by xjohnson View Post
    Thank you for the help but unfortunately it still goes to debug at the same line.
    Maybe not lucky

  5. #5
    Banned User!
    Join Date
    10-12-2018
    Location
    Texas
    MS-Off Ver
    2010
    Posts
    358

    Re: Rename Tabs Issue

    Yes today not so lucky I hope things will improve for me.

    Thank you for trying

  6. #6
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Rename Tabs Issue

    Try
    Please Login or Register  to view this content.
    However, you will need to check invalid characters or length of A1, if needed.

  7. #7
    Banned User!
    Join Date
    10-12-2018
    Location
    Texas
    MS-Off Ver
    2010
    Posts
    358

    Re: Rename Tabs Issue

    Thank you Jindon that worked great!

  8. #8
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Rename Tabs Issue

    You are welcome and thanks for the rep.

  9. #9
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Rename Tabs Issue

    Not sure why going to column O invokes the macro since I can't see any sheet event macro
    However the code fails because some sheets don't have a value in A1.

    And as a general rule avoid merged cells like A1:B1 on the Service Log and others.

    You'd also assist have assisted us if you had removed the sheets password protection.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ 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. Rename tabs using a VBA loop
    By tommytommy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-28-2014, 01:36 PM
  2. [SOLVED] Rename Tabs
    By ILoveStMartin in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-30-2013, 12:18 AM
  3. Rename worksheet tabs and sheets to match tabs via button
    By timgavin in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-31-2011, 06:12 PM
  4. Rename tabs
    By fatalcore in forum Excel General
    Replies: 5
    Last Post: 02-07-2011, 10:42 AM
  5. Mass rename tabs
    By kisboros in forum Excel General
    Replies: 7
    Last Post: 02-10-2010, 03:49 AM
  6. Rename existing tabs
    By Dawn Rhoads in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-27-2005, 05:05 PM
  7. Programatically Rename Tabs
    By Karl Burrows in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-21-2005, 09: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