Sub 添加信息()
Dim s变量 As String Dim s As String s = "变量"
s变量 = Cells(Range("B65536").End(xlUp).Row + 1, 1)
Range("B6:M6").Select
Selection.Copy
Cells(Range("B65536").End(xlUp).Row + 1, 2).Select
ActiveSheet.Paste
Application.CutCopyMode = False
Selection.Replace What:="模板", Replacement:=s
End Sub