Copy & paste value from / to worksheets

ipbr21054

Well-known Member
Joined
Nov 16, 2010
Messages
2,997
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

MrExcel MVP
Joined
Nov 12, 2010
Messages
11,711
Office Version
365, 2010
Platform
Windows, Mobile
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?
 
Last edited:

Forum statistics

Threads
1,084,933
Messages
5,380,652
Members
401,695
Latest member
dwoychowski

Some videos you may like

This Week's Hot Topics

Top