Sub Transmit() If Selection.Count < 2 Then Exit Sub Set c = Application.InputBox("请选择目标区域的第一个单元格", Type:=8) i = 0 Set c = IIf(c.Count = 1, c, c(1, 1)) For Each cel In Selection c.Offset(0, i) = cel i = i + 1 Next If MsgBox("清除原内容吗?", vbYesNo) = vbYes Then Selection.ClearContents End Sub本回答被提问者采纳