PASTE SPECIAL

V

VJR

Well-Known Member
Hi ashish.kumar21031995,

You can check the 'Paste' action of the MS Excel VBO which has a parameter as 'Values Only'. You'll need to use this action in conjunction with the 'Select' action. Or if you would like to use the existing Copy Paste Worksheet as Range then you would need to make a minor code change.

Take a look at Post #6 here where both the approaches are explained.

Post back how it goes with you.
 
You must log in or register to reply here.
Top