PasteSpecial value
thank you Gary & Chip;
following code worked for me;
vSourceWS.Range("N500:W" & vSourceLastRow + 1).Copy
vTargetWS.Range("F" & vTargetLastRow + 1).PasteSpecial Paste:=xlPasteValues
"Atif" wrote:
Here are two example of Code. Trying to copy Range of cells from SourceWS to
TargetWS.
This code working fine, as I have formula at Source its copy Formul.
vSourceWS.Range("N" & vSourceLastRow).CurrentRegion.Copy vTargetWS.Range("F"
& vTargetLastRow)
I tried to use PasteSpecial in result receiving Syntex Error
vSourceWS.Range("N" & vSourceLastRow).CurrentRegion.Copy _
vTargetWS.Range("F" & vTargetLastRow).PasteSpecial Paste:=xlPasteValues
Whats worng!
Regards
Atif
|