+ Reply to Thread
Results 1 to 5 of 5

Revisions Macro (Change The Last Letter in Cell)

  1. #1
    Registered User
    Join Date
    01-20-2016
    Location
    United States, Mi
    MS-Off Ver
    2013
    Posts
    2

    Revisions Macro (Change The Last Letter in Cell)

    New user to Macros am slowly gaining experience.

    Currently I am using a Macro to copy an entire line then delete out the last letter in the first column of the newly copied line. Additionally, it corrects the formula used to determine the most recent revision. This is efficient but it could be more efficient. Please, see below for current used Macro.
    Please Login or Register  to view this content.
    Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

    The letter being deleted is a revision letter essentially a string of 16 numbers (total) that ends in a revision letter. Revision Letters occur alphabetically (A, B, C, etc.).

    I am looking for a way to instead of only deleting the letter but change it to the next subsequent letter.

    Any and all help is appreciated!

    Thank you for your time!
    Last edited by MaxxAsian; 01-21-2016 at 02:09 PM.

  2. #2
    Forum Expert Crooza's Avatar
    Join Date
    10-19-2013
    Location
    Hunter Valley, Australia
    MS-Off Ver
    Excel 2003 /7/10
    Posts
    1,912

    Re: Revisions Macro (Change The Last Letter in Cell)

    This is untested. If it doesn't work post your sheet up.

    Try this

    Please Login or Register  to view this content.
    Happy with my advice? Click on the * reputation button below

  3. #3
    Registered User
    Join Date
    01-20-2016
    Location
    United States, Mi
    MS-Off Ver
    2013
    Posts
    2

    Re: Revisions Macro (Change The Last Letter in Cell)

    This formula worked great! But information was added that I previously did not have

    The first created string will always end in 0 and then the revisions will do as I stated previously.

    I believe what I will need to use is an IFF input in order to replace the last character if it is a 0 and replace it with an A.

    I am not sure how to exactly approach that.

  4. #4
    Forum Expert Crooza's Avatar
    Join Date
    10-19-2013
    Location
    Hunter Valley, Australia
    MS-Off Ver
    Excel 2003 /7/10
    Posts
    1,912

    Re: Revisions Macro (Change The Last Letter in Cell)

    I'll fix it shortly. Is 0 the only option for the last letter other than A to Z?

  5. #5
    Forum Expert Crooza's Avatar
    Join Date
    10-19-2013
    Location
    Hunter Valley, Australia
    MS-Off Ver
    Excel 2003 /7/10
    Posts
    1,912

    Re: Revisions Macro (Change The Last Letter in Cell)

    Here you go. 0 becomes A, A becomes B, B becomes C and so on...

    Please Login or Register  to view this content.

+ 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. Very confused! Is there a way to change a letter to a shape in the same cell?
    By alyssa88 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-10-2014, 02:06 PM
  2. Replies: 1
    Last Post: 06-26-2014, 06:03 AM
  3. [SOLVED] Conditional Formatting to change text in cell if other cell contains specific letter
    By RichTea88 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-06-2014, 06:47 AM
  4. Revisions to Macro
    By alachape in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 07-02-2008, 02:11 PM
  5. Auto change colour of cell when text / letter entered into cell
    By Nik_AU in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-26-2007, 07:36 AM
  6. Replies: 2
    Last Post: 07-26-2005, 03:05 AM
  7. [SOLVED] change a cell colour when entering a letter
    By paul42770 in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 06-27-2005, 04:05 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