Copy & Paste
SourceRange.Copy
destrange.Select
Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _
xlNone, SkipBlanks:=False, Transpose:=False
Regards,
Stefi
€žnc€ ezt Ã*rta:
1. Set sourceRange = mybook.Worksheets(1).Range("A1:L60")
2. Set destrange = basebook.Worksheets("Form temp").Range("A1")
3. sourceRange.Copy destrange
How can I change statement 3. above to copy and paste only values and number
format?
|