作者:麦土豆1937 | 来源:互联网 | 2023-05-19 04:39
IwanttodeleteallrowsbetweennamedrangesrbTopandrbBottom我想删除命名范围rbTop和rbBottom之间的所有行Ran
I want to delete all rows between named ranges rbTop and rbBottom
我想删除命名范围rbTop和rbBottom之间的所有行
Range("rbBottom").Value = ""
Range("rbTop").Select
Do While (Selection.Offset(1, 0).Value <> "")
Selection.Offset(1, 0).EntireRow.Delete
Loop
This works, but I want a slightly shorter way
这有效,但我想稍微缩短一下
Range("rbTop").Select
Do While (Selection.Offset(1, 0).Name <> "rbBottom") // how to write this line ?
Selection.Offset(1, 0).EntireRow.Delete
Loop
1 个解决方案