+ Reply to Thread
Results 1 to 4 of 4

Macro that converts today()+3 in to text on 2 columns

  1. #1
    Registered User
    Join Date
    12-07-2012
    Location
    england
    MS-Off Ver
    Excel 2010
    Posts
    10

    Macro that converts today()+3 in to text on 2 columns

    Hi all,

    I had a perfectly working macro for 1 column which when the work sheet is saved, the macro converts any formulas on a column that has today()+3 in, into a text, so when it saves, the date remains static.

    I now need this macro to do the same job within 2 columns, however, it fails to pick up on the second column. This is my macro so far:

    Please Login or Register  to view this content.
    Any help would be greatly appreciated it.

    The original macro that works perfectly on 1 column is:

    Please Login or Register  to view this content.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux - O365
    Posts
    12,262

    Re: Macro that converts today()+3 in to text on 2 columns

    Your post does not comply with Rule 5 of our Forum RULES. We have Seven question forums: Miscellaneous, General, Programming, Worksheet Functions, Charting, Excel 2007 Help and New Users. Please choose the appropriate forum, and post your question in ONLY one forum.

  3. #3
    Registered User
    Join Date
    12-07-2012
    Location
    england
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Macro that converts today()+3 in to text on 2 columns

    Quote Originally Posted by Pepe Le Mokko View Post
    Your post does not comply with Rule 5 of our Forum RULES. We have Seven question forums: Miscellaneous, General, Programming, Worksheet Functions, Charting, Excel 2007 Help and New Users. Please choose the appropriate forum, and post your question in ONLY one forum.
    My apologies, I will post it in the Worksheet Functions. This post can be deleted if necessary.

  4. #4
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    19,297

    Re: Macro that converts today()+3 in to text on 2 columns

    phish3rz, it should actually go in the Programming forum because you are asking about VBA.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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