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

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



On Nov 11, 12:24*am, headly <hea...@discussions.microsoft.com> wrote:
> 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

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

Barb Reinhardt



"headly" wrote:

> 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

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.

--
Regards,

OssieMac


"headly" wrote:

> 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

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.

--
Regards,

OssieMac


"headly" wrote:

> 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