Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
deleting record with a range
I have a range of rows with data withi them. say 100 rows. on the
sheet theres acell in which you enter a number say 20. And the program deletes all the rows within the range except the first 20, I am using a very simple code at the moment but i am sure could be done better counter = Range("e11") Range("e15").Select Do Until countert = counter ActiveCell.Offset(1, 0).Select countert = countert + 1 Loop Do Until ActiveCell = "" ActiveCell.EntireRow.Delete Loop as you see the user determines the number of records he wants by entering a number in range E11. This does work fine but I am trying to learn better programming methods where I am not actively moving around a worksheet, any suggestions |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
deleting record with a range
counter = Range("e11")
FirstRow = 15 DeleteRow = FirstRow + counter LastRow = Range("E" & Rows.Count).End(xlup).Row rows(DeleteRow & ":" & Lastrow).Delete " wrote: I have a range of rows with data withi them. say 100 rows. on the sheet theres acell in which you enter a number say 20. And the program deletes all the rows within the range except the first 20, I am using a very simple code at the moment but i am sure could be done better counter = Range("e11") Range("e15").Select Do Until countert = counter ActiveCell.Offset(1, 0).Select countert = countert + 1 Loop Do Until ActiveCell = "" ActiveCell.EntireRow.Delete Loop as you see the user determines the number of records he wants by entering a number in range E11. This does work fine but I am trying to learn better programming methods where I am not actively moving around a worksheet, any suggestions |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to combine each record into a range? | Excel Discussion (Misc queries) | |||
Copy a record before deleting | Excel Programming | |||
Copy a record before deleting | Excel Programming | |||
Deleting a record from Access data base using programming from excel | Excel Programming | |||
Deleting Range name's listed in the range address box. | Excel Discussion (Misc queries) |