<div>
what is the default of pasting if not mention Paste:=xlPasteFormulasvalu<wbr />es or Paste:=xlPasteValues?<br />
<br />
Thanks<br />
Gvilbis
</div>


what is the default of pasting if not mention Paste:=xlPasteFormulasvalues or Paste:=xlPasteValues?

Thanks
Gvilbis

Clipboard01.jpg

<div>
<div class="content wysiwyg-content">
i would like to copy from one spreadsheet to another and i would like to know what is the command for copying value and for coping formula<br />
<br />
for example i have the following line, how its should be written for each case (for value and for formula)?<br />
<br />
wksDest.Range(Cells(rng.Ro<wbr />w, 244), Cells(rng.Row, 318)).Copy<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;wksSource.Activate<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Cells(lastRow + 1, 107).PasteSpecial xlPasteAll, Paste:=xlPasteCommens<br />
<br />
and what is the meaning of .PasteSpecial xlPasteAll<br />
<br />
Thanks<br />
Gvilbis
</div>
</div>


i would like to copy from one spreadsheet to another and i would like to know what is the command for copying value and for coping formula

for example i have the following line, how its should be written for each case (for value and for formula)?

wksDest.Range(Cells(rng.Row, 244), Cells(rng.Row, 318)).Copy
               wksSource.Activate
               Cells(lastRow + 1, 107).PasteSpecial xlPasteAll, Paste:=xlPasteCommens

and what is the meaning of .PasteSpecial xlPasteAll

Thanks
Gvilbis

i would like to know how do i am using paste specail in excel VBA

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

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.