Please help me guys : ) : )

[yeongkwe]

Hi, someone can kindly help me to solve this issue. I use the VBA code to filter the dates. I did some changes on the code, can anyone tell me did I do anything wrong? Because after I modify it, the search got no result coming out. Please kindly soul help me, and your help will be very much appreciated. Thanks you.

Sub Macro1()

abcd = Worksheets("sheet1").Cells(1, 101)
Range("A38:E38").Select
Selection.AutoFilter
ActiveSheet.Range("$A$38:$E$97375").AutoFilter Field:=5, Criteria1:= _"<15/08/2016", Operator:=xlAnd
" End Sub


Below is original code before I modify.

Sub Macro1()
'
' Macro1 Macro
' w
'
' Keyboard Shortcut: Ctrl+w
'

Range("A38:E38").Select
Selection.AutoFilter
ActiveSheet.Range("$A$38:$E$97375").AutoFilter Field:=5, Criteria1:= _
"<15/08/2016", Operator:=xlAnd
End Sub

 

[mart37]

[COLOR=#333333]Sub Macro1()[/COLOR]
[COLOR=#333333]abcd = Worksheets("sheet1").Cells(1, 101)[/COLOR]
[COLOR=#333333]ActiveSheet.Range("$A$38:$E$97375").AutoFilter Field:=5, Criteria1:= "<15/08/2016", Operator:=xlAnd[/COLOR]
[COLOR=#333333]End Sub[/COLOR]

why abcd?
sometimes you had to change dd/mm to mm/dd

 

[MARK858]

@yeongkwe, which of the 2 threads you have going has the correct question? as in this thread you state the modified code is

ActiveSheet.Range("$A$38:$E$97375").AutoFilter Field:=5, Criteria1:= _"<15/08/2016",

and in the thread below you have it as

  ActiveSheet.Range("$A$38:$E$97375").AutoFilter Field:=5, Criteria1:= _
        "<abcd", Operator:=xlAnd

Please help me guys : )

 

[Peter_SSs]

Duplicate to Please help me guys : )

Please do not post the same question multiple times. Questions of a duplicate nature will be locked or deleted, per #12 of the Forum Rules and points 6 & 7 of the Forum Use Guidelines.

Any bumps, clarifications, or follow-ups should be posted to the linked thread.