Did you try the above?Code:Range("Source_Range").Copy Range("Destinaton_Range").PasteSpecial Paste:=xlPasteValues
Are Source_Range and DEstination_Range variables or named ranges?
|
Results 1 to 3 of 3
Thread: Copying a Ranges Values Only
Threaded View
|
Click Here to Expand Forum to Full Width |
Reply With Quote