Sub aa() Dim r1 As Range Set r1 = ActiveSheet.UsedRange Debug.Print r1.EntireColumn.Address Rows(Range(Mid(r1.Address, InStr(1, r1.Address, ":") + 1)).Row).Select Columns(Range(Mid(r1.Address, InStr(1, r1.Address, ":") + 1)).Column).Select End Sub
Sub aa() Dim r1 As Range Set r1 = ActiveSheet.UsedRange Debug.Print r1.EntireColumn.Address Rows(Range(Mid(r1.Address, InStr(1, r1.Address, ":") + 1)).Row).Select Selection.Delete Columns(Range(Mid(r1.Address, InStr(1, r1.Address, ":") + 1)).Column).Select Selection.Delete End Sub
Sub aa() Dim r1 As Range Set r1 = ActiveSheet.UsedRange Debug.Print r1.EntireColumn.Address Rows(Range(Mid(r1.Address, InStr(1, r1.Address, ":") + 1)).Row).Select Selection.Delete Columns(Range(Mid(r1.Address, InStr(1, r1.Address, ":") + 1)).Column).Select Selection.Delete End Sub这里有个问题,根据你的这段代码运行,始终找不到最后有数据的那行。到底哪里还有问题?
FredLee2004(小小李)说的对,试试下面的: Sub aa() Dim r1 As Range Set r1 = ActiveSheet.UsedRange Debug.Print r1.EntireColumn.Address
Rows(r1.SpecialCells(xlCellTypeLastCell).Row).Select Selection.Delete Columns(r1.SpecialCells(xlCellTypeLastCell).Column).Select Selection.Delete End Sub
Debug.Print IsEmpty(Selection)----------------------------------------------
http://training.yesky.com/topic/topic_vba.htm
EXCEL中VBA的学习、宏的使用,涉及图表、菜单、数据库等方面。
全程视频教学,光盘有每一章的实例代码。第一章免费试学。
现在我的问题是这样的!
我要把EXCEL中最后有数据的那行(列)中的数据删掉,该怎么写?
谢谢!
Dim r1 As Range
Set r1 = ActiveSheet.UsedRange
Debug.Print r1.EntireColumn.Address
Rows(Range(Mid(r1.Address, InStr(1, r1.Address, ":") + 1)).Row).Select
Columns(Range(Mid(r1.Address, InStr(1, r1.Address, ":") + 1)).Column).Select
End Sub
Sub aa()
Dim r1 As Range
Set r1 = ActiveSheet.UsedRange
Debug.Print r1.EntireColumn.Address
Rows(Range(Mid(r1.Address, InStr(1, r1.Address, ":") + 1)).Row).Select
Selection.Delete
Columns(Range(Mid(r1.Address, InStr(1, r1.Address, ":") + 1)).Column).Select
Selection.Delete
End Sub
后来的办法我的比henrry的好,使用.SpecialCells(xlLastCell)可以获得最右下角一个单元格,然后就随便你删除都可以了呵呵。。
Dim r1 As Range
Set r1 = ActiveSheet.UsedRange
Debug.Print r1.EntireColumn.Address
Rows(Range(Mid(r1.Address, InStr(1, r1.Address, ":") + 1)).Row).Select
Selection.Delete
Columns(Range(Mid(r1.Address, InStr(1, r1.Address, ":") + 1)).Column).Select
Selection.Delete
End Sub这里有个问题,根据你的这段代码运行,始终找不到最后有数据的那行。到底哪里还有问题?
Sub aa()
Dim r1 As Range
Set r1 = ActiveSheet.UsedRange
Debug.Print r1.EntireColumn.Address
Rows(r1.SpecialCells(xlCellTypeLastCell).Row).Select
Selection.Delete
Columns(r1.SpecialCells(xlCellTypeLastCell).Column).Select
Selection.Delete
End Sub
别忘了给我计分哦,这可是我第一次得分哦。