Paste special from clipboard macros

[kreal]

Hello, people!

I have a macro: paste text from a clipboard and it works fine.
But if I record a macro with Paste Special from clipboard I get an error "Run-time error 424"

I need to have a macro with pasting text from clipboard matching destination formatting / paste special (text)

How can i fix this error or is there another way to make a macro like this one?

Hope excel pros would help me.

[Bernie Deitrick]

This single line should work:

Please Login or Register  to view this content.

[kreal]

Bernie, you're 100% correct and it works. Thanks a lot.