Copy & Paste
 

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?

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?

Copy & Paste
 

Thanks Stefi.

Does this mean I cannot simplify the statement to

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


"Stefi" wrote:

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?

Copy & Paste
 

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

Stefi


€žnc€� ezt Ã*rta:

Thanks Stefi.

Does this mean I cannot simplify the statement to

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


"Stefi" wrote:

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?