Sub 符号替换2()
Application.ScreenUpdating = False
Range("B7,L7:BW7").Replace "~*", "×"
'1替换
Range("B8, L8:BW8,L13:BW13").Replace "M", "O"
Range("B8, L8:BW8,L13:BW13").Replace "N", "P"
'2替换 Range("B6,B9:B10,L3:BW3,L5:BW5,L9:BW9,L10:BW10,L12:BW12").Replace "X", "A"
'3替换 Range("B6,B9:B10,L3:BW3,L5:BW5,L9:BW9,L10:BW10,L12:BW12").Replace "Y", "B"
'4替换 Range("B6,B9:B10,L3:BW3,L5:BW5,L9:BW9,L10:BW10,L12:BW12").Replace "Z", "C"
Application.ScreenUpdating = True
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
On Error Resume Next
If Not Intersect(Range("B6,B9:B10,L3:BW3,L5:BW3,L9:BW9,L10:BW10,L12:BW12"), Target) Is Nothing Then
Application.ScreenUpdating = False
符号替换2
Application.ScreenUpdating = True
End If
End Sub
|