trantuan11
New Member
- Joined
- Mar 27, 2016
- Messages
- 19
Dear Mr excel
In Chapter 12 I run Macro Dinamic date range using Autofilter not run, Please help me
Sub FilterDynamicDate()
' Page 255 Top
' Bug in the beta
Worksheets("NewFilter").Select
Range("A1:A1").AutoFilter Field:=3, _
Criteria1:=xlFilterDatesinPeriodQuarter1, Operator:=xlFilterDynamic
End Sub
it appear infomations " run-time error '1004'
Autofilter method of range class failed
please help me
In Chapter 12 I run Macro Dinamic date range using Autofilter not run, Please help me
Sub FilterDynamicDate()
' Page 255 Top
' Bug in the beta
Worksheets("NewFilter").Select
Range("A1:A1").AutoFilter Field:=3, _
Criteria1:=xlFilterDatesinPeriodQuarter1, Operator:=xlFilterDynamic
End Sub
it appear infomations " run-time error '1004'
Autofilter method of range class failed
please help me
Last edited: