copy/paste not working

[dzo]

Hi,
could you help me?
I use this vba in excel, to remove fill colors from cells, then Im entering any value, it's very helpfull.
But I notice that paste command didn't work in some reasons, that can I do to resolve this problem?
I don't want to use command button, because it isn't convenient.
Looking forward to your reply.

Please Login or Register  to view this content.

[VBA Noob]

dzo,

Welcome to the forum. Please read forum rules below. I've added you're code tags for you this time.

What do you mean by. Can you explain a bit more

paste command didn't work in some reasons

I assume you mean it needs to be automated not a button??

I don't want to use command button, because it isn't convenient.

VBA Noob

[royUK]

I can't see a paste command, also you don't set the Target like that. This might be what your code should be

Please Login or Register  to view this content.

[VBA Noob]

Roy,

Should

Please Login or Register  to view this content.

be

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

VBA Noob