+ Reply to Thread
Results 1 to 2 of 2

Macro to find dates past due in a column

  1. #1
    Registered User
    Join Date
    05-16-2005
    Posts
    11

    Macro to find dates past due in a column

    All,

    This is probably pretty simple, but I would like to make a macro that I could run that would look through a single column and highlight (in yellow) any dates that are more than 90 days from today.

    I will probably just call this macro from a command button so it will be obvious and easy to use.

    Thanks in advance.

  2. #2
    Forum Contributor
    Join Date
    12-12-2005
    Posts
    667
    Here is the basic code:
    Sub TestDate()
    Worksheets(3).Select
    e = Now() - 90
    For i = 1 To 6
    d = Cells(i, 1).Value
    If d < e Then
    MsgBox d
    End If
    Next
    End Sub
    Best regards,

    Ray

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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