本帖最后由 wangjiayu_1985 于 2016-7-11 09:00 编辑
我想把A1列里的数字分别替换成别的,一共有7个要替换的,这7个数量的多少不固定,我自己录制了一个宏,然后复制粘贴,也可以实现,但是感觉好麻烦,请问有简单的代码吗附件里有要替换的表格,
我录制了代码如下
Sub P1A()
Range("A3:A500").Select
Selection.Replace What:="1", Replacement:="CM1:1", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Range("A3:A500").Select
Selection.Replace What:="2", Replacement:="CM1:2", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Range("A3:A500").Select
Selection.Replace What:="3", Replacement:="CM1:3", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Range("A3:A500").Select
Selection.Replace What:="4", Replacement:="CM1:4", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Range("A3:A500").Select
Selection.Replace What:="5", Replacement:="CM1:5", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Range("A3:A500").Select
Selection.Replace What:="6", Replacement:="CM1:6", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Range("A3:A500").Select
Selection.Replace What:="7", Replacement:="CM1:7", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
End Sub
替换后
替换.rar
(21.17 KB, 下载次数: 5)
|