Copy & Paste

N

nc

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?
 
S

Stefi

SourceRange.Copy
destrange.Select
Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _
xlNone, SkipBlanks:=False, Transpose:=False

Regards,
Stefi

„nc†ezt írta:
 
N

nc

Thanks Stefi.

Does this mean I cannot simplify the statement to

3. sourceRange.Copy destrange PasteSpecial
Paste:=xlPasteValuesAndNumberFormats, Operation:= _
xlNone, SkipBlanks:=False, Transpose:=False
 
S

Stefi

You can't! PasteSpecial works only from the clipboard!

Stefi


„nc†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy from multiple workbooks and display the original worksheet na 1
Copy information to the last row of another sheet in excel 2003 3
VBA code for pasting links -- modifying RDB code for summary workbook 10
automatically run script 2
why won't this vba work, when this one does... 6
copy COLUMN from 1 worksheet to another (in a different workbook) 3
In multiple sheet copy error subscript out of range ?? HELP 4
Set sourceRange 1

Top