advanced filter office 2007

[tina]

Hi
I recently upgraded to office 2007 and my macro does not do the advanced
filter correctly now only putting in headings no data . If I stop macro do
advanced filter it works . I recorded advanced filter and put in macro which
then fails but worked while recording.
below is appropiate part of macro
Columns("A:G").Select
Range("A:G").AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Range( _
"I1:I2"), CopyToRange:=Range("K1"), Unique:=False
Any ideas ?
Thank you
Tina

 

[tina]

Thank you for the reply Joel
unfortunatly exactly same result
the data is from a microsft query but I copied and paste special values to
new sheet and copied new macro of advanced filter while copying it worked
when ran after failed
so weird
Regards
Tina