Results 1 to 11 of 11

Advanced Filter between two formatted Dates

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-01-2011
    Location
    England
    MS-Off Ver
    Excel 365
    Posts
    126

    Advanced Filter between two formatted Dates

    hi all,

    I have a code filtering my database table by dates actually between two dates, but it's not workin with me

    and i dont know WHY

    please, anyone reviews that

    the code in userform2

    Private Sub filter_Click()
    Sheet2.Activate
    Sheet1.[i3] = TextBox1.Value
    Sheet1.[j3] = TextBox2.Value
    Sheet1.Range("j2").FormulaR1C1 = "=If(AND(R[5]C>=R3C9,R[5]C<=R3C10),TRUE,"""")"
    Sheet1.Range("C6:R65536").AdvancedFilter Action:=xlFilterCopy, CopyToRange:= _
      Sheet2.Range("C6:R6"), CriteriaRange:=Sheet1.Range("C1:R2"), Unique:=False
    End Sub
    Attached Files Attached Files
    Last edited by Mamud; 03-09-2012 at 07:51 AM.

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