<div>
Record a macro while doing it and then edit the macro to see how it's done. 
</div>


Record a macro while doing it and then edit the macro to see how it's done.

<div>
i do not want a macro, my code in vbscript is pretty large and I need to add this piece to it...
</div>


i do not want a macro, my code in vbscript is pretty large and I need to add this piece to it...

<div>
Is there anyone that can help?
</div>


<div>
 &nbsp; &nbsp;Range(&quot;D113:F113&quot;).Select<br />
&nbsp; &nbsp; Selection.Copy<br />
&nbsp; &nbsp; Range(&quot;T97&quot;).Select<br />
&nbsp; &nbsp; Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _<br />
&nbsp; &nbsp; &nbsp; &nbsp; :=False, Transpose:=False
</div>


   Range("D113:F113").Select
    Selection.Copy
    Range("T97").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False

<div>
BillPrew, you Rock... &nbsp;You are awesome your help has allowed me to learn a lot more about VBS and how to use it correctly. &nbsp;Thank you so much
</div>


BillPrew, you Rock...  You are awesome your help has allowed me to learn a lot more about VBS and how to use it correctly.  Thank you so much

<div>
Glad that helped, and thanks so much for the kind works, and grade.<br />
<br />
~bp
</div>


Glad that helped, and thanks so much for the kind works, and grade.

~bp

<div>
<div class="content wysiwyg-content">
I would like to know how to use paste special values in to Excel. I have played around with <br />
oSheet2.Range(&quot;B3&quot;).PasteS<wbr />pecial = Value, but It does not work. &nbsp;<br />
<br />
Can you help ?<br />
<br />
thank you
</div>
</div>


I would like to know how to use paste special values in to Excel. I have played around with 
oSheet2.Range("B3").PasteSpecial = Value, but It does not work.  

Can you help ?

thank you

Paste Special

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.