gvilbis
asked on
i would like to know how do i am using paste specail in excel VBA
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.Ro w, 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
for example i have the following line, how its should be written for each case (for value and for formula)?
wksDest.Range(Cells(rng.Ro
wksSource.Activate
Cells(lastRow + 1, 107).PasteSpecial xlPasteAll, Paste:=xlPasteCommens
and what is the meaning of .PasteSpecial xlPasteAll
Thanks
Gvilbis
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks
Gvilbis