i would like to know how do i am using paste specail in excel VBA
Posted on 2014-01-19
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
Cells(lastRow + 1, 107).PasteSpecial xlPasteAll, Paste:=xlPasteCommens
and what is the meaning of .PasteSpecial xlPasteAll