Sub Button2_Click()
Dim se As Worksheet
For Each se In Worksheets
If se.Name <> "数据提取" Then
With se
.Range("I1:K1").Copy
End With
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End If
Next
End Sub
弄反了吧,应该是这样吧。
Sub Button2_Click()
Dim se As Worksheet
Selection.Copy
For Each se In Worksheets
If se.Name <> "数据提取" Then
se.Range("I1:K1").PasteSpecial Paste:=xlPasteValues
End If
Next
End Sub
弄反了吧,应该是这样吧。
Sub Button2_Click()
Dim se As Worksheet
Selection.Copy
For Each se In Worksheets
If se.Name <> "数据提取" Then
se.Range("I1:K1").PasteSpecial Paste:=xlPasteValues
End If
Next
End Sub