Copy and Paste VBA code error

[gan_xl]

The following code shows error, trying to change two lines code into one for faster execution.

Please Login or Register  to view this content.

Please help me to correct this.

[vcoolio]

Hello Gan_xl,

Try putting this part:-

Please Login or Register  to view this content.

onto the next line.

Cheerio,
vcoolio.

[YasserKhalil]

Try this

Please Login or Register  to view this content.

Note that the quotation in your post is not correct .. It would be " not “
In one line you would not use PasteSpecial

[Naveed Raza]

Hi gan_xl,

Note: at single line Pastespecial will not work , if you want to paste special value then that line should be at next line then only it will work.

Please Login or Register  to view this content.

[gan_xl]

Thanks everybody for taking time to respond me. I am already using 2 lines code and expecting one line code. But now I understand it is not possible. Thanks again.

[xlnitwit]

Hi,

You don't need to copy for this.

Please Login or Register  to view this content.