+ Reply to Thread
Results 1 to 3 of 3

Compare dates in first column of table

  1. #1
    Registered User
    Join Date
    11-18-2013
    Location
    Indi
    MS-Off Ver
    Excel 2007
    Posts
    9

    Compare dates in first column of table

    Hi All,

    In the below macro I am trying to compare dates in the cells of first column and see if they have been sorted properly from smaller to bigger (When table size is big, Word is messing it up ). If any date is out of order I just want to highlight the "out of order" date with wdPink. If the cells contain non-numeric characters I don't want to compare them. Usually the cell contents are numeric or alpha. If the cell content is numeric, then the cell content is only dates and the date format is MM/DD/YY. I wrote the below one, but I think my logic behind the code is wrong and have to rewrite it. I am very much new to this and I am really sorry if I am making blunders. Please help.

    Please Login or Register  to view this content.

  2. #2
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Compare dates in first column of table

    Your code is over-engineered. Try:
    Please Login or Register  to view this content.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  3. #3
    Registered User
    Join Date
    11-18-2013
    Location
    Indi
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: Compare dates in first column of table

    Thank you! It is working perfect

+ 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. Pivot table to compare sent and received dates
    By patch in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-28-2014, 04:17 AM
  2. How to compare 2 columns of dates - Pivot Table
    By patch in forum Excel General
    Replies: 0
    Last Post: 03-27-2014, 08:56 PM
  3. Replies: 4
    Last Post: 02-18-2014, 07:29 PM
  4. [SOLVED] Compare dates across columns and return column header
    By huy_le in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-29-2013, 07:07 PM
  5. Replies: 1
    Last Post: 07-12-2010, 02:10 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