'---------------------------------------------------
'功能:删除选定区域中所有汉字
'发布:http://www.
'---------------------------------------------------
Sub DelAllHanzi()
Dim Rg As Range, Rg1 As Range
Dim xAddress As String
On Error Resume Next
xAddress = ActiveSheet.UsedRange.Address
Set Rg = Application.InputBox("请选择一个区域:", "ExcelFans.com", xAddress, , , , , 8)
If Rg Is Nothing Then Exit Sub
Set Rg = Application.Intersect(Rg, ActiveSheet.UsedRange)
If Rg Is Nothing Then Exit Sub
For Each Rg1 In Rg
Rg1 = ExtractHanzi(Rg1, False)
Next
End Sub |