Application.ScreenUpdating = False s = Selection.Count ReDim arr(s - 1) For Each Rng In Selection arr(i) = Rng.Address i = i + 1 Next Range("xfd1").PasteSpecial (xlPasteAll) For i = 0 To s - 1 Range("xfd1").Offset(i, 0).Cut Range(arr(i)).Select ActiveSheet.Paste Next i Application.ScreenUpdating = True
Set MyData = New DataObject Application.ScreenUpdating = False MyData.GetFromClipboard arr = Split(MyData.GetText(1), Chr(13) + Chr(10)) i = 0 For Each Rng In Selection Rng.Value = arr(i) i = i + 1 Next Set MyData = Nothing Application.ScreenUpdating = True