PasteSpecial Values

[Zheno]

Hey!

Have a small VBA code that simply copy a row and then paste it on first empty row in another sheet. Its working if i use a regular macro, but i have some problems to get it to work with some code. I want it as VBA since the copying is alot smoother.

The problem i have in the code is the PasteSpecial.value, Since i dont want the formula to get pasted.

Attachiing the worksheet. Its the macro PasteSpecial that i need alittle guiding on if possible.

[6StringJazzer]

Your Sub TestDis does exactly what you want it to do. Using Copy with the Destination argument does not. What do you want to do in Sub PasteSpecial that you can't do in TestDis as written?

[Zheno]

Your Sub TestDis does exactly what you want it to do. Using Copy with the Destination argument does not. What do you want to do in Sub PasteSpecial that you can't do in TestDis as written?

No because when i run it i get the message (translated from swedish) "Error no.'1004' Couldnt find the PasteSpecial property for the Range class"

EDIT*

Yes the TestDIS does what i want. When i run that macro tho it gets a delay and a jump between the diffrent workbooks. Witch im trying to avoid. The PasteSpecial code makes it smooth and no switching between the workbooks is done

[Richard Buttrey]

Hi,

You can't use the Copy Destination:= construction with values. Instead try

Please Login or Register  to view this content.

[Zheno]

Hi,

You can't use the Copy Destination:= construction with values. Instead try

Please Login or Register  to view this content.

There we go!!!

Awesome, Thank you.