|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
Sub 清除()
Dim k
Dim c
c = Sheet2.Cells(1, Columns.Count).End(xlToLeft).Column
k = Sheet2.Cells(Rows.Count, c).End(xlUp).Row
If k = 1 Then Exit Sub
Range([a2], Cells(k, c)).ClearContents
End Sub
Sub test()
Dim k, str
Dim rng As Range
Set rng = Sheet1.Cells(1, Columns.Count).End(xlToLeft)
str = rng.Address
' 查找第一个$的位置
startPos = InStr(str, "$") + 1
' 查找第二个$的位置
endPos = InStr(startPos, str, "$")
' 使用Mid提取两个$之间的字符串
Dim X As String
X = Mid(str, startPos, endPos - startPos)
k = Sheets("数据源").Cells(Rows.Count, X).End(xlUp).Row
Sheets("数据源").Range("A1:" & X & k).AdvancedFilter Action:=xlFilterCopy, _
CopyToRange:=Range("A1:O1"), Unique:=False
End Sub |
评分
-
1
查看全部评分
-
|