+ Reply to Thread
Results 1 to 4 of 4

How to erase the name of a cell using macros?

  1. #1
    Registered User
    Join Date
    10-08-2014
    Location
    Varginha
    MS-Off Ver
    Office 2007
    Posts
    5

    How to erase the name of a cell using macros?

    Hello,

    My question is simple: how to erase the name of a cell in a macro?
    I gave a name to a cell, but now I want to remove the name (without removing the content of the cell)

    The excel version is 2007

    Thanks in advance,
    Luis

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,648

    Re: How to erase the name of a cell using macros?

    May be this.....

    Please Login or Register  to view this content.
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  3. #3
    Registered User
    Join Date
    10-08-2014
    Location
    Varginha
    MS-Off Ver
    Office 2007
    Posts
    5

    Re: How to erase the name of a cell using macros?

    It worked! Thanks a lot

  4. #4
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,648

    Re: How to erase the name of a cell using macros?

    You're welcome. Glad it worked.
    If that takes care of your question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.
    Moreover you may also click on * (star) to Add Reputation if the solution provided helped you. This is another way to say thanks.

+ 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] button erase dont erase an image inserted on an image control
    By Nuno Neves in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-11-2014, 08:04 AM
  2. How to erase some words on a cell?
    By Gravity101 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-21-2013, 07:36 AM
  3. [SOLVED] Erase cell that are unprotect AND not in the first row.
    By Melisendk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-11-2013, 02:34 AM
  4. [SOLVED] Macros code to erase data
    By Brainstorm in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-10-2012, 09:06 PM
  5. [SOLVED] how to erase all spaces in text cell?
    By D in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-23-2006, 03:45 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