Paste values by criteria.

**ANDREAAS** · 06-04-2020, 07:01 AM

Hi All

How do i change the following code to paste the values only.

Please Login or Register  to view this content.

Thank you in advance for any help.

**Kaper** · 06-04-2020, 07:12 AM

Try:

Please Login or Register  to view this content.

**Arkadi** · 06-04-2020, 07:14 AM

Try changing

Please Login or Register  to view this content.

to:

Please Login or Register  to view this content.

**jindon** · 06-04-2020, 07:15 AM

Untested

Please Login or Register  to view this content.

**ANDREAAS** · 06-05-2020, 01:28 AM

Thanks very much @Kaper, works perfectly.

**ANDREAAS** · 06-05-2020, 01:30 AM

thx @Arcadi, but i tried this before and it brings up an error.

**ANDREAAS** · 06-05-2020, 01:32 AM

Also works, thx @jindon

**Kaper** · 06-05-2020, 01:56 AM

Hi,

Glad to hear that, and thanks for marking thread as Solved and for the reputation point :-)

Re: Paste values by criteria.