lior03
06-19-2006, 01:27 AM
hello
i found this code in a john walkenbach book.
i am trying to use a refedit to copy a selection from a cell to another.
Dim Msg As String
Msg = "Source = " & Me.RefEdit1.Value & vbNewLine
Selection.Copy
Msg = Msg & "Destination = " & Me.RefEdit2.Value & vbNewLine
ActiveSheet.Paste
Application.CutCopyMode = False
MsgBox Msg
what wrong with this code?
thanks
i found this code in a john walkenbach book.
i am trying to use a refedit to copy a selection from a cell to another.
Dim Msg As String
Msg = "Source = " & Me.RefEdit1.Value & vbNewLine
Selection.Copy
Msg = Msg & "Destination = " & Me.RefEdit2.Value & vbNewLine
ActiveSheet.Paste
Application.CutCopyMode = False
MsgBox Msg
what wrong with this code?
thanks