Zhiv4ik
Пробуйте так:
Код:
Sub test()
Dim s1$, s2$
Dim oCBrd As DataObject
Set oCBrd = New DataObject
Cells(1, 1).Copy
oCBrd.GetFromClipboard
s1 = Cells(2, 1).Value
s2 = oCBrd.GetText
Cells(2, 1).Value = s1 & s2
Set oCBrd = Nothing
End Sub
Пробуйте так:
Код:
Sub test()
Dim s1$, s2$
Dim oCBrd As DataObject
Set oCBrd = New DataObject
Cells(1, 1).Copy
oCBrd.GetFromClipboard
s1 = Cells(2, 1).Value
s2 = oCBrd.GetText
Cells(2, 1).Value = s1 & s2
Set oCBrd = Nothing
End Sub