How can I correct the runtime error 1004, in Excel 2003, did not get the error in 2000

I receive a run time error when using Excel 2003, I did not receive the error when I used Excel 2000. I just loaded 2003. The error is : Run time error "1004" "Paste method of worksheet class failed"
Here is some of the code:

Range("B1").Select
    Sheets("CEMENT").Select
    Selection.AutoFilter Field:=9, Criteria1:=">=8"
    Selection.AutoFilter Field:=3, Criteria1:="214"
    Columns("AK:AK").Select
    Selection.Copy
    Sheets("GRAPH DATA").Select
   
    ActiveSheet.Paste
    Range("C1").Select
    Sheets("CEMENT").Select
    Range("A5").Select
    Selection.AutoFilter Field:=3, Criteria1:="215"
    Columns("AK:AK").Select
    Application.CutCopyMode = False
    Selection.Copy
    Sheets("GRAPH DATA").Select
    ActiveSheet.Paste
    Range("D1").Select
    Sheets("CEMENT").Select
    Selection.AutoFilter Field:=3, Criteria1:="335"
    Columns("AK:AK").Select
    Application.CutCopyMode = False
    Selection.Copy
    Sheets("GRAPH DATA").Select
    ActiveSheet.Paste
    Range("E1").Select
entrerriAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Mikal613Commented:
which line?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
entrerriAuthor Commented:
I talked with Microsoft on this one. The problem was, when copying a filtered column, Excel 2003 wanted to copy the filter as well. Excel 2000 only copied the data in the filtered column. The code "ActiveSheet.paste" will try to paste the filter and the runtime error will occur. The fix was to change the code to copy the column, then paste special, then value. Microsoft says this only happends when the record macro function is used, and that it has been reported as a bug. A fix will be out soon in on of the updates.
0
entrerriAuthor Commented:
please refund didn't get what i wanted
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.