学习Excel技术,关注微信公众号:excelperfect
标签:VBA,自定义函数如下图1所示,在单元格A1中包含多行文本,现在要求删除这些文本中开头单词相同的行,仅保留第1行,结果如图1单元格B1中所示。图1可以使用VBA编写一个自定义函数来实现。打开VBE,插入一个标准模块,输入代码:Public Function fnUnique(rng As Range) Dim dict As Object Dim dOut As Object Dim val As Variant Dim var As Variant Dim i As Integer Dim sKey As String Set dict = CreateObject("scripting.dictionary") Set dOut = CreateObject("scripting.dictionary") dict.CompareMode = vbTextCompare dOut.CompareMode = vbTextCompare val = rng.Value & "" var = Split(val, Chr(10)) On Error Resume Next For i = 0 To UBound(var) sKey = Split(var(i))(0) If dict.exis
………………………………