Excel2003 Advanced Filter not working in Excel 2010

[sateeshshetty]

Hi,

We have a macro in Excel 2003 which we are trying to run in Excel 2010. The following code throws an error which we are not able to resolve. Please help us in resolving it.


sheets(sourcesheetname).range("a5").currentregion.advancedfilter action:=xlfiltercopy, _criteriarange:=range("$t$" & col1 & ":$v$" & col2), _copytorange:=range("a" & currstatestart & ":m" & currstatestart), unique:=false


The way the Range is specified looks fine but an error arises with it

 

[gsteinert]

You appear to be copying to a 13 column range (A?:M?) from a 3 column range ($T$?:$V$?). This may be the root of your problem.