Modify code VBA to copy contents only, not formula

**Mayweed** · 08-29-2010, 08:03 PM

Can anyone please tell me how to stop this code from copying the formulas from each cell; I only want it to copy the contents of the cell?

Please Login or Register  to view this content.

**venkat1926** · 08-29-2010, 10:48 PM

Please Login or Register  to view this content.

(10, 2)

insteqd of this try

Please Login or Register  to view this content.

**DonkeyOte** · 08-30-2010, 02:45 AM

or avoid the clipboard altogether:

Please Login or Register  to view this content.

**Mayweed** · 08-30-2010, 09:36 AM

Thank you Venkat1926 and DonkeyOte, I decided to go with avoiding the clipboard, works perfectly.
Your help is much appreciated.

Re: Help needed to modify this VBA to copy content only, not formula