先说结论:整套课程内容框架挺不错,然而过于宽泛,讲解的知识点比较单薄,2299的价格不推荐各位购买。课程简介本门课程为数据分析师系列P1课程,覆盖了中美大...
-
-
VBA根据关键字删除整行
Sub 删除行() Dim r As Integer Dim i As Integer, rng As Range With Sheet1 r = .Cells(Rows.Count, 1).End(xlUp).Row For i = r To 2 Step -1 If .Cells(i, 4) = "翠云" Then If rng Is Nothing Then Set rng = .Rows(i) Else Set rng = Union(rng, .Rows(i)) End If End If Next i rng.Delete End With End Sub
Excel,为何我在学校就不多鼓捣鼓捣呢?出来上班,不懂这玩意真的累死人