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

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


"joel" wrote:

>
> See if these changes help
>
> with ActiveSheet
> .Columns("A:G").AdvancedFilter Action:=xlFilterCopy, _
> CriteriaRange:=.Range("I1:I2"), _
> CopyToRange:=.Range("K1"), Unique:=False
> end with
>
>
> --
> joel
> ------------------------------------------------------------------------
> joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229
> View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=154699
>
> Microsoft Office Help
>
> .
>