+ Reply to Thread
Results 1 to 2 of 2

Macro for changing year

  1. #1
    Forum Contributor
    Join Date
    03-08-2007
    Location
    St. Augustine, Fl
    MS-Off Ver
    Excel 2021 for Mac
    Posts
    368

    Macro for changing year

    B4 VA1-13
    B5 VA2-13
    B6 VA3-13
    B7 VA4-13
    B8 VA5-13
    B9 VA6-13
    B10 VA7-13
    B11 VA8-13
    B12 VA9-13
    B13 VA10-13
    B14 VA11-13
    B15 VA12-13

    The above are items I would like to change grammatically using the 13 making it go to 14 all the way up to 47. The VA1-VA12 represents each month and the 13 to 47 will represent the years. Is there a simple way to do this?

  2. #2
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,445

    Re: Macro for changing year

    Select the range, CRTL plus H

    Find what: *13

    Replace with: 14

+ 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] I have the day and month but not the Year-need a macro to calculate the Year
    By iplayball in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-31-2013, 01:31 AM
  2. [SOLVED] Macro to Retrieve Data with Start Year and End Year
    By boldcode in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-17-2013, 01:09 PM
  3. Replies: 0
    Last Post: 09-04-2012, 04:27 PM
  4. changing the year of a date
    By zapszipszops in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-13-2006, 11:57 PM
  5. [SOLVED] Changing the value of a year in a given format
    By cdbiggs in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-03-2006, 07:40 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