怎样用VB宏执行：在excel中的单元格里删除不想要的字符？
1个回答
展开全部
Sub 按钮1_单击()
a = Selection.Row
a1 = Selection.Rows.Count
b = Selection.Column
b1 = Selection.Columns.Count
For i = a To a + a1 - 1
For j = b To b + b1 - 1
Cells(i, j) = Replace(Cells(i, j), "aaaa", "")
'Cells(i, j) = Replace(Cells(i, j), Range("a1"), "")
Next j
Next i
End Sub
先选择区域
必须是连续的区域哦
a = Selection.Row
a1 = Selection.Rows.Count
b = Selection.Column
b1 = Selection.Columns.Count
For i = a To a + a1 - 1
For j = b To b + b1 - 1
Cells(i, j) = Replace(Cells(i, j), "aaaa", "")
'Cells(i, j) = Replace(Cells(i, j), Range("a1"), "")
Next j
Next i
End Sub
先选择区域
必须是连续的区域哦
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
