Paste Special (Value) for my Code

Hi,

Below is my code to copy from A1 and paste in B1. My problem is it is copying the cell's background color, which I don't require. So i need to somehow incorporate paste special (values) into the code, but every time I try this I get an error.

Please Login or Register  to view this content.

Any help will be appreciated.

Thanks,

Just use PasteSpecial/Values. The only thing is it cannot be combined on 1 line like the COPY command...

Please Login or Register  to view this content.

Try this

Please Login or Register  to view this content.

Another:

Please Login or Register  to view this content.

Dam, was hoping that there was a way of keeping it all on one line, like below or something. All good, thanks for both your help.

Please Login or Register  to view this content.

Hi John, been using the code you have provided as well, but I have to put it into a loop for when I have a range of cells. Thanks though.

Wait! John sorry just tried the below and it seemed to have worked, didn't think it would for a range, but it has. Thanks!!!

Please Login or Register  to view this content.

You're welcome. Glad to help out.