My userform consists of a refedit box and a command button..after
selecting the range with the refedit box i want to paste the selected
range from cell "E1"...everything works perfectly but it does not paste
the selected range into "E1".....i used the following code:

Private Sub CommandButton1_Click()
With Range(RefEdit1)
..Copy
..Range("e1").PasteSpecial
End With
End Sub

I will appriciate some help

Thanks
Theuns


--
T.c.Goosen1977
------------------------------------------------------------------------
T.c.Goosen1977's Profile: http://www.excelforum.com/member.php...o&userid=35895
View this thread: http://www.excelforum.com/showthread...hreadid=559815