| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting a group of rows
Is it possible to use the Rows property to delete a range of rows in one
statement in a macro, or must I use a loop and .Rows(I).Delete for each row one at a time? Dan |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Deleting a group of rows
Range("M14:O14").EntireColumn.Delete
"Dan" skrev: Is it possible to use the Rows property to delete a range of rows in one statement in a macro, or must I use a loop and .Rows(I).Delete for each row one at a time? Dan |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Deleting a group of rows
excelent wrote:
Range("M14:O14").EntireColumn.Delete or even EntireRow |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Deleting a group of rows
As a guess you intended rows not columns...
Range("M14:O14").EntireRow.Delete Deleting is one of those slow things to do in Excel. You are always better off to create one single large range area and delete it all at once than to delete a bunch of rows one at a time. The rows do not have to be continuious either Range("A1:A5", "A10:A15").entirerow.delete -- HTH... Jim Thomlinson "excelent" wrote: Range("M14:O14").EntireColumn.Delete "Dan" skrev: Is it possible to use the Rows property to delete a range of rows in one statement in a macro, or must I use a loop and .Rows(I).Delete for each row one at a time? Dan |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Deleting a group of rows
do you mean this?
Sub delrows() Rows("17:19").Delete 'or 'Rows(17).Resize(3).Delete End Sub -- Don Guillett SalesAid Software "Dan" wrote in message ... Is it possible to use the Rows property to delete a range of rows in one statement in a macro, or must I use a loop and .Rows(I).Delete for each row one at a time? Dan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Group rows (or hide rows) like in MS Project | Excel Worksheet Functions | |||
| Macro for deleting rows and serialising the remaing rows | Links and Linking in Excel | |||
| Deleting a space between a group of Numbers & Letters in a cell | New Users to Excel | |||
| deleting hidden rows so i can print only the rows showing?????? | Excel Worksheet Functions | |||
| Deleting minimized Rows in a group | Excel Programming | |||
Linear Mode
