Advanced Filter - error message

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mifty - 25 May 2006 00:52 GMT

Hi there,

Can anyone tell me what the following message means and how to stop it please

'The extract range has a missing or illegal field name'

In simple language please - not even sure what extract range and field name
are.

The filter works. It puts the data expected into the cell I tell it to but
an error message pops up afterwards.

I would be grateful for any answers.

Cheers
Mifty

Signature

Mifty

Reply to this Message

Debra Dalgleish - 25 May 2006 13:52 GMT

The extract range is where you want the filter results to start. The
range can be blank, or can contain headings that exactly match headings
from the source table. (You can use some or all of the headings from the
source table.)

A field is a column in the source table.

Usually you get that message if a heading in the extract range isn't
identical to one of the headings in the source table.

> Hi there,
>
[quoted text clipped - 12 lines]
> Cheers
> Mifty

Signature

Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply to this Message

Mifty - 25 May 2006 19:02 GMT

Many thanks for your reply. Will have another try and let you know

Signature

Mifty

> The extract range is where you want the filter results to start. The
> range can be blank, or can contain headings that exactly match headings
[quoted text clipped - 22 lines]
> > Cheers
> > Mifty

Reply to this Message