<div>
<div class="content wysiwyg-content">
Hi Guys, I recorded a Macro for a daily process whereby I put an auto-filter on row 3.Then do End(xlDown) and copy the region. However, the Macro recorded the exact Row range and it will be variable every day so I need to adapt it. <br />
Rows(&quot;3:3&quot;).Select<br />
&nbsp; &nbsp; Selection.AutoFilter<br />
&nbsp; &nbsp; ActiveSheet.Range(&quot;$A$3:$R<wbr />$166&quot;).Aut<wbr />oFilter Field:=13, Criteria1:=&quot;&gt;=1&quot;, _<br />
&nbsp; &nbsp; &nbsp; &nbsp; Operator:=xlOr, Criteria2:=&quot;&lt;=-1&quot;<br />
<br />
Any ideas?<br />
<br />
Justin
</div>
</div>


Hi Guys, I recorded a Macro for a daily process whereby I put an auto-filter on row 3.Then do End(xlDown) and copy the region. However, the Macro recorded the exact Row range and it will be variable every day so I need to adapt it. 
Rows("3:3").Select
    Selection.AutoFilter
    ActiveSheet.Range("$A$3:$R$166").AutoFilter Field:=13, Criteria1:=">=1", _
        Operator:=xlOr, Criteria2:="<=-1"

Any ideas?

Justin

Filter Range problem in Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.