+ Reply to Thread
Results 1 to 3 of 3

Filter/Delete for Certain Date&Time

Hybrid View

  1. #1
    Registered User
    Join Date
    02-20-2009
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    92

    Re: Filter/Delete for Certain Date&Time

    Thanks for the response guy. I actually was able to figure it out using some stuff I googled.

    For anyone interested, I used something like this:
    Dim dDate As Date, dTime As Date
    Dim strDate As String
    Dim lDate As Long, dblTime As Double
    Dim dDateTime As Double
    
    Range("D4").Select
    Do Until ActiveCell.Value = ""
    ActiveCell.Offset(1, 0).Select
    If ActiveCell.Value <= dDateTime Then
    Selection.EntireRow.Delete
    End If
    Loop
    Range C1 on my sheet is a formula using Workday -1 to get prior business day.
    Last edited by starcraftbud; 06-09-2011 at 02:19 PM.

+ 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