error 1004 when cutting and pasting special

[flunzy]

Hi guys,

I need some help for an error that occurs when cutting and pasting. I'm trying to cut the outcome of a formula ans paste it somewhere else but I get an error 1004. Could some help me with this error : $

Please Login or Register  to view this content.

[alansidman]

What is the full error message and which line of code is highlighted when you get the message?

[flunzy]

What is the full error message and which line of code is highlighted when you get the message?

Hi Alansidman,

Hereby the code:

Please Login or Register  to view this content.

and hereby the highlightened text:

Please Login or Register  to view this content.

]

[flunzy]

anyone a solution?

[alansidman]

I cleaned up the Select and Selections to make this run faster. See if that helps the situation

Please Login or Register  to view this content.

[watersev]

hi flunzy, if you use PasteSpecial after Cut it will not work. It will work after Copy is used only.

Workaround for your particular case basing on the cleaned up code by alansidman:

Replace those lines from post #5:

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.