Copy Method of Range Class Failed

[g48dd]

Excel 2003: I don't write VBA but I can do some tweaking, I have code that moves data according to day of the week, Originaly this code used the cut method and that worked but I need it to copy and paste special. I used the macro recorder to record something where you Past Special so I could see what the syntax was. I have tried it in several spots but I can not make it work, this is the code as it stands now:

Please Login or Register  to view this content.

the error message is "Copy Method of Range Class Failed and it highlights Saturday because today is saturday and that is where it is trying to move that data. I am guessing I get the message because it does not know how I want to move it or what I want to do with it? That is why I need this:

Please Login or Register  to view this content.

But I have tried placing it in several places and I am just not getting it right, could I get a little help and if you have time maybe small explantion of what I was doing wrong?

Thanks Ken

[DonkeyOte]

Ken,

I'm not quite sure what you're looking to do with PasteSpecial but in general terms you might look to use something along the lines of:

Please Login or Register  to view this content.

If you wish to only ever copy the values you can avoid using the clipboard (copy) altogether should you so wish.

[g48dd]

Thank you,

"If you wish to only ever copy the values you can avoid using the clipboard (copy) altogether should you so wish."

I just want the values from column E10:E nothing else and I want to leave those values in place, so I was trying to use Past Special, there is a better way?

Thanks
Ken

[DonkeyOte]

If you want only the values then you can avoid the clipboard, e.g.:

Please Login or Register  to view this content.

[g48dd]

I am not sure but I am beginning to wonder if my brain is ok, I just took two days off so I could work on this spread sheet, Thank you it works just fine, I really appreciate your help.

Ken