代碼如:
sub tihuan()
with activesheet.usedrange.cells
.replace "張三","test"
end with
end sub
如果有個人名字:張三9,那么會被替換為 : test9
請問怎么解決這個問題?
uj5u.com熱心網友回復:
if aaaa="張三" then bbbb="test9"uj5u.com熱心網友回復:
Sub tihuan()
With ActiveSheet.UsedRange.Cells
.Replace "張三", "test", LookAt:=1
End With
End Sub
轉載請註明出處,本文鏈接:https://www.uj5u.com/gongcheng/16878.html
標籤:VBA
上一篇:VBA程式撰寫
下一篇:VB VB 井字棋 井字棋小程式
