Adv filter fails in macro, works fine manually

[headly]

Excel 2007 is giving me such a headache;

Recorded macro code
Columns("B2:B2819").AdvancedFilter Action:=xlFilterCopy, _
CopyToRange:=Range("AB65000"), Unique:=True

Should extract 6 values

When run from inside a procedure it fails to extract anything;
When run manually without a macro running it works fine;
Additional info: Column A is already filtered to 1 value, now I need to get
the associated values from column B; At this point i have already ran extract
unique on column A with no problem

 

[muddan madhu]

Range("B2:B2819").AdvancedFilter Action:=xlFilterCopy,
CopyToRange:=Range( _
"AB65000"), unique:=True

 

[Barb Reinhardt]

I don't do advanced filtering, but I don't see any criteria.

 

[OssieMac]

Problem is Columns("B2:B2819")

Should be or Columns("B:B")
or
Range("B1:B2819")

Note that the header must be included when using advanced filter or the
first value becomes the column header in the filtered range.

 

[OssieMac]

My apologies if this post twice. I got an error when trying to post the first
time.

The problem is Columns("B2:B2819")

Should be or Columns("B:B")
or
Range("B1:B2819")

Note that the header must be included when using advanced filter or the
first value becomes the column header in the filtered range.