+ Reply to Thread
Results 1 to 4 of 4

Deleting column based on Column header date less than today

  1. #1
    Registered User
    Join Date
    09-16-2017
    Location
    London
    MS-Off Ver
    Office 2016
    Posts
    24

    Deleting column based on Column header date less than today

    Hi All,

    I want to delete a number of columns which have a date which is less than today.

    I get "Method 'Range' of object '_Global' failed at the "Set rngCol" line and I can't see where I've gone wrong.

    Any help appreciated.

    Please Login or Register  to view this content.

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Deleting column based on Column header date less than today

    Try this:

    Please Login or Register  to view this content.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Registered User
    Join Date
    09-16-2017
    Location
    London
    MS-Off Ver
    Office 2016
    Posts
    24

    Re: Deleting column based on Column header date less than today

    Perfect!. Thank you!

  4. #4
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Deleting column based on Column header date less than today

    You're welcome!

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. 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] Return different values in a cell from different column ranges, based on today`s date
    By schmidta1988 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-03-2016, 07:07 AM
  2. [SOLVED] How to fill an array with values in column C based on Column D date value of Today
    By jrtraylor in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-10-2016, 07:44 PM
  3. [SOLVED] Count cell values under column with today's date header
    By jben86 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-23-2013, 03:19 PM
  4. [SOLVED] Single column countif with moving range based on today's date
    By JonesyCC in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-16-2013, 02:45 PM
  5. Deleting row based on date in particular column
    By aserle in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-29-2013, 05:57 AM
  6. Finding a column value based on date and column header
    By soready42012 in forum Excel General
    Replies: 0
    Last Post: 01-18-2012, 06:21 PM
  7. Replies: 3
    Last Post: 09-01-2011, 01:47 PM

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