1

Topic: Macro of the filter an interval on dates

Children prompt what not so?, I try to construct the filter for an output on an interval of dates, but it is impossible

Sub an interval ()
ActiveSheet. Range ("$N$2: $ N$2000").AutoFilter Field: = 1, Criteria1: = Format (DTPicker1, "DD/MM/YYYY"), _
Operator: = xlAnd, Criteria2: = Format (DTPicker2, "DD/MM/YYYY")
End Sub

2

Re: Macro of the filter an interval on dates

And what though not ? Only not a videoclip on , please...

3

Re: Macro of the filter an interval on dates

Akina,  also shows blank lines

4

Re: Macro of the filter an interval on dates

Akina, an example

5

Re: Macro of the filter an interval on dates

assei wrote:

Akina,

You it tried to open an example? By OTHER machine,  mine.

6

Re: Macro of the filter an interval on dates

Akina, yes it is valid, corrected

7

Re: Macro of the filter an interval on dates

assei,

8

Re: Macro of the filter an interval on dates

iMrTidy, at it is much grateful!