Paste no borders and values
 

I have a piece of code that runs the following:
Selection.PasteSpecial Paste:=xlPasteAllExceptBorders, Operation:=xlNone,
SkipBlanks:=False, Transpose:=False

I would also like it to paste values and not links. How can both of these be
accomplished?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200705/1

Paste no borders and values
 

On May 4, 3:38 pm, "brownti via OfficeKB.com" <u31540@uwe wrote:
I have a piece of code that runs the following:
Selection.PasteSpecial Paste:=xlPasteAllExceptBorders, Operation:=xlNone,
SkipBlanks:=False, Transpose:=False

I would also like it to paste values and not links. How can both of these be
accomplished?

--
Message posted via OfficeKB.comhttp://www.officekb.com/Uwe/Forums.aspx/excel-programming/200705/1

Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone,
SkipBlanks:= False, Transpose:=False

Try that!

Hope that helps!

-LT

Paste no borders and values
 

Execute two lines of code:

Selection.PasteSpecial Paste:=xlPasteAllExceptBorders, _
Operation:=xlNone, _
SkipBlanks:=False, _
Transpose:=False
Selection.PasteSpecial Paste:=xlValues

--
Regards,
Tom Ogilvy


"brownti via OfficeKB.com" wrote:

I have a piece of code that runs the following:
Selection.PasteSpecial Paste:=xlPasteAllExceptBorders, Operation:=xlNone,
SkipBlanks:=False, Transpose:=False

I would also like it to paste values and not links. How can both of these be
accomplished?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200705/1