+ Reply to Thread
Results 1 to 4 of 4

Refedit copy paste problem?

  1. #1
    Registered User
    Join Date
    06-29-2006
    Posts
    60

    Refedit copy paste problem?

    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

  2. #2
    Registered User
    Join Date
    06-29-2006
    Posts
    60
    Got it right....i must change my code from:

    Private Sub CommandButton1_Click()
    With Range(RefEdit1)
    .Copy
    .Range("e1").PasteSpecial
    End With
    End Sub
    to:
    Private Sub CommandButton1_Click()
    sheet13.Range(RefEdit1).select
    selection.copy
    sheet13.Range("e1").selects
    selection.pastespecial

    End Sub

    Theuns

  3. #3
    Registered User
    Join Date
    06-29-2006
    Posts
    60
    Got it right....i must change my code from:

    Private Sub CommandButton1_Click()
    With Range(RefEdit1)
    .Copy
    .Range("e1").PasteSpecial
    End With
    End Sub
    to:
    Private Sub CommandButton1_Click()
    sheet13.Range(RefEdit1).select
    selection.copy
    sheet13.Range("e1").selects
    selection.pastespecial

    End Sub

    Theuns

  4. #4
    Registered User
    Join Date
    06-29-2006
    Posts
    60
    Got it right....i must change my code from:

    Private Sub CommandButton1_Click()
    With Range(RefEdit1)
    .Copy
    .Range("e1").PasteSpecial
    End With
    End Sub
    to:
    Private Sub CommandButton1_Click()
    sheet13.Range(RefEdit1).select
    selection.copy
    sheet13.Range("e1").selects
    selection.pastespecial
    End With
    End Sub

    Theuns

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1