Copy & PasteSpecial
 

Range("A1").Copy
Range ("C1:C5").PasteSpecial (xlPasteValues)

This copies and pastes like I want, but it leaves
the range C1:C5 selected, and cell A1 has the blinking
dotted outline to show it is on the clipboard ready to be
pasted. Is there a way to copy and paste values without
these secondary effects?

Art

Copy & PasteSpecial
 

Hi Arthur

Sub test1()
Range("A1").Copy
Range("C1:C5").PasteSpecial (xlPasteValues)
Range("C1").Select
Application.CutCopyMode = False
End Sub

If you only want to copy the value you can use this also

Sub test2()
Range("C1:C5").Value = Range("A1").Value
End Sub




--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Arthur" wrote in message ...
Range("A1").Copy
Range ("C1:C5").PasteSpecial (xlPasteValues)

This copies and pastes like I want, but it leaves
the range C1:C5 selected, and cell A1 has the blinking
dotted outline to show it is on the clipboard ready to be
pasted. Is there a way to copy and paste values without
these secondary effects?

Art