Advanced Filter. Fully Qualified Reference?

[nigelk]

Hi all,

I have an advanced filter that gets it's data from one sheet (ImportSh) , its' criteria from another (ShtName) and puts the output to a third sheet (TempData)

This is the code I've got

ImportSh.Columns("E:L").AdvancedFilter Action:=xlFilterCopy, _
        CriteriaRange:=Sheets(ShtName).Range("A1:A2"), CopyToRange:=Sheets(TempData).Range("A1:H1") _
        , Unique:=False

But I get a 'type mismatch' error.
I'm thinking it's because its not fully qualified.

Can anyone help?
Thanks,Nigel

 

[Norie]

Nigel

As far as I can see all the ranges are fully qualified.

Sometimes advanced filter can throw up some strange errors.

Have you checked all the data, criteria etc?

I've had this error, or similar, a few times and can remember at least once it seemed to have something to do with the destination worksheet.

It already had data on it and I think the headers didn't quite match with the original data.

I didn't think that would matter, and I don't know if it was the problem.

Anyway I just ended up using a temporary worksheet for an 'intermediate' destination and copying from that to the real destination.

Seemed to work and wasn't too much trouble.

 

[nigelk]

Thanks Norrie,

I think I'll go down that path.

Nigel.