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
Bookmarks