我想用另一个单词替换列中的单词,但我的代码似乎不起作用,我仍在努力掌握编程语言,但对我来说它并不直观。
情况:
Global Macro - Equities
Global Macro - Bonds
Global Macro - FX
.
.
.
And so on...
希望的结果:
GM - Equities
GM - Bonds
GM - FX
.
.
.
我的代码
Sub ReplaceFundNames()
Dim FundName As String
Dim CorrectedName As String
Dim ws As Worksheet
Dim LastRow As Long
Set ws = ActiveSheet
LastRow = Range("B" & Rows.Count).End(xlDown).Row
FundName = Range(LastRow)
CorrectedName = Replace(FundName, "Global Macro", "GM")
Range("B" & LastRow).Value = CorrectedName
End Sub
谢谢!
B1048576
进行替换,仅当该单元格包含"Global Macro"
时才进行替换。 - ThunderFrame