MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

COPY method fails when I have (auto)filtered my view of records

  Asked By: Fern    Date: Nov 21    Category: MS Office    Views: 1628

I am having an issue with
the .COPY method

If I run my procedure without an autofilter selection active (with
all rows shown) then all is fine.

However, if I chose to limit my view of records by setting on an
autofilter selection, then I get an 1004 error : Copy Method of
Range class failed.

The offending line is:

The various variables stated in the line of code have good values
when I look at them via the debugger.

I am using Excel 2003.



No Answers Found. Be the First, To Post Answer.