AdvancedFilter Excel2007 - time period

[Beate Schmitz]

Hello,

I have following sample-data:

<table border="1" cellspacing="0" cellpadding="0" style="font-family:Arial,Arial; font-size:10pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:71px;" /><col style="width:60px;" /><col style="width:44px;" /><col style="width:44px;" /><col style="width:108px;" /><col style="width:108px;" /><col style="width:60px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td style=" border-width:3px; border-style:ridge;border-color:#f0f0f0; ">A</td><td style=" border-width:3px; border-style:ridge;border-color:#f0f0f0; ">B</td><td style=" border-width:3px; border-style:ridge;border-color:#f0f0f0; ">C</td><td style=" border-width:3px; border-style:ridge;border-color:#f0f0f0; ">D</td><td style=" border-width:3px; border-style:ridge;border-color:#f0f0f0; ">E</td><td style=" border-width:3px; border-style:ridge;border-color:#f0f0f0; ">F</td><td style=" border-width:3px; border-style:ridge;border-color:#f0f0f0; ">G</td></tr><tr style="height:17px ;" ><td style="border-width:3; border-style:ridge;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >1</td><td style="font-weight:bold; ">Date</td><td style="font-weight:bold; ">Value</td><td style="font-weight:bold; "> </td><td style="font-weight:bold; "> </td><td style="font-weight:bold; ">Date</td><td style="font-weight:bold; ">Date</td><td style="font-weight:bold; ">Value</td></tr><tr style="height:17px ;" ><td style="border-width:3; border-style:ridge;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >2</td><td style="text-align:right; ">1/1/2007</td><td style="text-align:right; ">23.63</td><td > </td><td > </td><td style="text-align:center; ">>=1/14/2007</td><td style="text-align:center; "><=1/22/2007</td><td > </td></tr><tr style="height:17px ;" ><td style="border-width:3; border-style:ridge;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >3</td><td style="text-align:right; ">1/2/2007</td><td style="text-align:right; ">98.10</td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="border-width:3; border-style:ridge;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >4</td><td style="text-align:right; ">1/3/2007</td><td style="text-align:right; ">65.11</td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="border-width:3; border-style:ridge;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >5</td><td style="text-align:right; ">1/4/2007</td><td style="text-align:right; ">6.26</td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="border-width:3; border-style:ridge;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >6</td><td style="text-align:right; ">1/5/2007</td><td style="text-align:right; ">55.31</td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="border-width:3; border-style:ridge;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >7</td><td style="text-align:right; ">1/6/2007</td><td style="text-align:right; ">61.08</td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="border-width:3; border-style:ridge;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >8</td><td style="text-align:right; ">1/7/2007</td><td style="text-align:right; ">62.26</td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="border-width:3; border-style:ridge;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >9</td><td style="text-align:right; ">1/8/2007</td><td style="text-align:right; ">88.37</td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="border-width:3; border-style:ridge;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >10</td><td style="text-align:right; ">1/9/2007</td><td style="text-align:right; ">56.46</td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="border-width:3; border-style:ridge;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >11</td><td style="text-align:right; ">1/10/2007</td><td style="text-align:right; ">44.71</td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="border-width:3; border-style:ridge;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >12</td><td style="text-align:right; ">1/11/2007</td><td style="text-align:right; ">13.74</td><td > </td><td > </td><td style="color:#0000ff; "> </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="border-width:3; border-style:ridge;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >13</td><td style="text-align:right; ">1/12/2007</td><td style="text-align:right; ">28.54</td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="border-width:3; border-style:ridge;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >14</td><td style="text-align:right; ">1/13/2007</td><td style="text-align:right; ">27.19</td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="border-width:3; border-style:ridge;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >15</td><td style="text-align:right; ">1/14/2007</td><td style="text-align:right; ">73.43</td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="border-width:3; border-style:ridge;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >16</td><td style="text-align:right; ">1/15/2007</td><td style="text-align:right; ">50.59</td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="border-width:3; border-style:ridge;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >17</td><td style="text-align:right; ">1/16/2007</td><td style="text-align:right; ">14.87</td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="border-width:3; border-style:ridge;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >18</td><td style="text-align:right; ">1/17/2007</td><td style="text-align:right; ">44.60</td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="border-width:3; border-style:ridge;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >19</td><td style="text-align:right; ">1/18/2007</td><td style="text-align:right; ">73.62</td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="border-width:3; border-style:ridge;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >20</td><td style="text-align:right; ">1/19/2007</td><td style="text-align:right; ">74.57</td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="border-width:3; border-style:ridge;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >21</td><td style="text-align:right; ">1/20/2007</td><td style="text-align:right; ">42.54</td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="border-width:3; border-style:ridge;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >22</td><td style="text-align:right; ">1/21/2007</td><td style="text-align:right; ">80.76</td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="border-width:3; border-style:ridge;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >23</td><td style="text-align:right; ">1/22/2007</td><td style="text-align:right; ">31.59</td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="border-width:3; border-style:ridge;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >24</td><td style="text-align:right; ">1/23/2007</td><td style="text-align:right; ">87.92</td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="border-width:3; border-style:ridge;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >25</td><td style="text-align:right; ">1/24/2007</td><td style="text-align:right; ">65.73</td><td > </td><td > </td><td style="font-weight:bold; "> </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="border-width:3; border-style:ridge;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >26</td><td style="text-align:right; ">1/25/2007</td><td style="text-align:right; ">89.15</td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="border-width:3; border-style:ridge;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >27</td><td style="text-align:right; ">1/26/2007</td><td style="text-align:right; ">76.43</td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="border-width:3; border-style:ridge;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >28</td><td style="text-align:right; ">1/27/2007</td><td style="text-align:right; ">81.31</td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="border-width:3; border-style:ridge;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >29</td><td style="text-align:right; ">1/28/2007</td><td style="text-align:right; ">75.04</td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="border-width:3; border-style:ridge;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >30</td><td style="text-align:right; ">1/29/2007</td><td style="text-align:right; ">87.17</td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="border-width:3; border-style:ridge;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >31</td><td style="text-align:right; ">1/30/2007</td><td style="text-align:right; ">7.51</td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="border-width:3; border-style:ridge;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >32</td><td style="text-align:right; ">1/31/2007</td><td style="text-align:right; ">91.75</td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="border-width:3; border-style:ridge;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >33</td><td style="text-align:right; ">2/1/2007</td><td style="text-align:right; ">92.02</td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="border-width:3; border-style:ridge;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >34</td><td style="text-align:right; ">2/2/2007</td><td style="text-align:right; ">98.44</td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="border-width:3; border-style:ridge;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >35</td><td style="text-align:right; ">2/3/2007</td><td style="text-align:right; ">9.36</td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="border-width:3; border-style:ridge;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >36</td><td style="text-align:right; ">2/4/2007</td><td style="text-align:right; ">2.66</td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="border-width:3; border-style:ridge;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >37</td><td style="text-align:right; ">2/5/2007</td><td style="text-align:right; ">30.84</td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="border-width:3; border-style:ridge;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >38</td><td style="text-align:right; ">2/6/2007</td><td style="text-align:right; ">51.55</td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="border-width:3; border-style:ridge;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >39</td><td style="text-align:right; ">2/7/2007</td><td style="text-align:right; ">40.43</td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="border-width:3; border-style:ridge;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >40</td><td style="text-align:right; ">2/8/2007</td><td style="text-align:right; ">15.27</td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="border-width:3; border-style:ridge;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >41</td><td style="text-align:right; ">2/9/2007</td><td style="text-align:right; ">25.00</td><td > </td><td > </td><td > </td><td > </td><td > </td></tr></table>

Under Excel2003 it was possible to filter a period of time by this code:

Sub Spezialfilter2()
Columns("A:B").AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:=Range _
("E1:G2"), Unique:=False
End Sub

Using the same code under Excel2007 there are no results. What has changed?

Filtering the same under Excel2007 by hand (i.e. without code) works.

Any ideas?