>Does anyone know what cause the runtime error "1004" ... "advancedfilter method of range class failed". there is no caviots in the Excel VB reference help index. I feel like it is a reference to a list. this is the code "Range("ItembyReten").AdvancedFilter Action:=xlFilterCopy, CriteriaRange:= Range("Criteria"), CopyToRange:=Range("Extract"), Unique:=False".
>
>Thanks in advance, Chuck
Chuck,
This doesn't seem to be an official call from VFP to Excel. You're using 'named arguments' (Action := xlFilterCopy ...). Search for 'named argument' here on UT and you'll get details.
Cetin