Refedit copy paste problem?

T

T.c.Goosen1977

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Refedit copy paste problem? 3
Taking control from Option Button into RefEdit in Excel 2010 behaving oddly 4
Formatting and copy or copy and formatting ?? 2
Copy columns and paste with blank column between 5
A simple if <> nn then Msgbox "No Match" 5
Should I be content with the time code takes? 2
Print Refedit range? 3
Copy to Visible Cells only;Modify Code 11

Top