Copy & paste value from / to worksheets

[ipbr21054]

Hi,
Long story short.

A code used say 4 months ago has now raised a problem so i need to fix 4 months of worksheets.

Ive now sorted out the worksheet & all is ok.
My task now is to copy the values from one worksheet to another worksheet.

Sounds easy but sometimes i see a message about source etc etc.
I also just wish to copy values only and not formulas etc.

The worksheet it will be pasted to will have formulas in cells but my only other option is to type every value out.

Can you advise how i do this correctly without the source message when i try to paste

Thanks

 

[MARK858]

Would you like to post some info like the ranges that you are pasting from and to and the names of the worksheets? also can you elaborate on what you mean by "The worksheet it will be pasted to will have formulas in cells" are you overwriting the formulas?

Sounds easy but sometimes i see a message about source etc etc

Can you post the exact message that you are getting and the code that you are using?

 

[ipbr21054]

Hi,
Thanks but i managed to do it all last night
Have a nice day