+ Reply to Thread
Results 1 to 2 of 2

Date after Filter Date with VBA not show

  1. #1
    Registered User
    Join Date
    03-08-2021
    Location
    thailand
    MS-Off Ver
    8
    Posts
    2

    Date after Filter Date with VBA not show

    I use VBA for filter Date in excel as below.

    Sub FilterDate (Date2 as String)

    Sheets("Cash").Select
    MsgBox (Date2)

    Range("E1").Select
    Selection.AutoFilter
    ActiveSheet.Range("$A$1:$J$373").AutoFilter Field:=5, Criteria1:= _
    "<"& Date2 , Operator:=xlAnd
    End Sub
    MsgBox show 31/05/2021

    But output after filter show blank.

    Capture.JPG

    Please guide me for solve it.

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    2016 primarily
    Posts
    6,301

    Re: Date after Filter Date with VBA not show

    Try:

    Please Login or Register  to view this content.
    Rory
    I drink, and I know things

+ 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] Date filter, show only 2 days ago and older
    By arsentievalex in forum Excel General
    Replies: 1
    Last Post: 03-18-2020, 12:44 PM
  2. Excel table date filter not show all years to select
    By ericbsw in forum Excel General
    Replies: 8
    Last Post: 07-21-2017, 04:45 PM
  3. Need to Show Min and Max date within Filter
    By excelnovice936 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-22-2016, 04:22 PM
  4. Filter by Date and Show in LisView
    By marreco in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-23-2014, 01:13 PM
  5. [SOLVED] need help to lookup a (workday) date, and then excel output to show that date minus 1
    By Marijke in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-23-2013, 11:13 AM
  6. Replies: 0
    Last Post: 05-12-2010, 05:01 PM
  7. Filter on date and show most recent
    By NMullis in forum Excel General
    Replies: 1
    Last Post: 03-10-2010, 12:51 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