学习Excel技术,关注微信公众号:excelperfect
标签:VBA这是在www.vbaexpress.com中看到的一个示例,个人觉得代码很有代表性,特辑录于此,与大家共享。示例数据如下图1所示。图1想要删除行和列中的空单元格,变成如下图2所示。图2可以使用下面的VBA代码:Sub DeleteEmpty() Dim r As Long, c As Long Dim rLast As Range, rData As Range, rEnd As Range Application.ScreenUpdating = False With ActiveSheet Set rLast = .Cells.Find(What:="*", _ After:=Range("A1"), _ LookAt:=xlPart, _ LookIn:=xlFormulas, _ SearchOrder:=xlByRows, _ SearchDirection:=xlPrevious, _ MatchCase:=False) Set rData = Range(.Cells(1, 1), rLast) With rData '删除空字符串使之成为真的空单元格 .Replace What:="", Replacement:="###", LookAt:=xlPart .Replace What:="###", Replacement:="", LookAt:=xlPart '删除空列 For c = .Colum
………………………………