+ Reply to Thread
Results 1 to 3 of 3

VBA code to delete columns older than 3 days

  1. #1
    Registered User
    Join Date
    06-01-2016
    Location
    Singapore
    MS-Off Ver
    13
    Posts
    55

    VBA code to delete columns older than 3 days

    Hello Team,

    I need your help in modifying the below code. Its serving the purpose. However, I have to click on the button more than once to get the desired result.
    I am not sure, what is wrong in this code.

    I need to delete columns older than 3 days. Everyday columns gets updated and I need to delete the column older than 3 days. 1st Row contains Date.

    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: VBA code to delete columns older than 3 days

    Maybe go from last column to the first column.

    Not tested.
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    06-01-2016
    Location
    Singapore
    MS-Off Ver
    13
    Posts
    55

    Re: VBA code to delete columns older than 3 days

    That worked, thank you

+ 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. Replies: 8
    Last Post: 07-02-2014, 01:39 PM
  2. Replies: 3
    Last Post: 09-12-2013, 12:37 AM
  3. [SOLVED] Comparing dates 4 days older or more
    By dlamberth in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-11-2013, 07:03 PM
  4. [SOLVED] Archive anything older than 90 days and if actioned = Yes
    By gwsampso in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-22-2012, 10:22 PM
  5. Macro to compare multiple columns then delete rows with older dates
    By azurememories in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-23-2011, 05:43 PM
  6. tying to code as msgbox if date is older than 30 days
    By Zygoid in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-19-2007, 10:20 AM
  7. [SOLVED] Dates older than 29 days
    By ab in forum Excel General
    Replies: 2
    Last Post: 06-16-2005, 05: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