Sub 预约()
x = 36
y = Sheets(6).[m65535].End(xlUp).Row - 1
y2 = Sheets(3).[f65535].End(xlUp).Row - 1
ReDim arr(1 To y, 1 To x), brr(1 To y2, 1 To x)
arr = Sheets(6).Range("A2").Resize(y, x).Value
brr = Sheets(3).Range("A2").Resize(y2, x).Value
For i = 1 To y2
For i2 = 1 To y
If brr(i, 6) = arr(i2, 13) Then
brr(i, 30) = arr(i2, 28)
brr(i, 31) = arr(i2, 29)
brr(i, 32) = arr(i2, 30)
brr(i, 36) = arr(i2, 35)
End If
Next
Next
'也可指定从Sheets(3)的哪一列到哪一列,单元格格式是文本
Sheets(3).Range("A2").Resize(y2, x).EntireColumn.NumberFormat = "@"
Sheets(3).Range("A2").Resize(y2, x) = brr
End Sub
把输出区域设置为文本格式,就不会出现了