| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
faster method to delete rows
I'm using this code to delete unwanted rows, testing column A and leaving
values between 1 and 12, in a database: LastRow = wksSheet.Cells(Rows.Count, "A").End(xlUp).Row For x = LastRow To 2 Step -1 ' If .Cells(x, 1).Value < 1 Or .Cells(x, 1) 12 Then .Cells(x, 1).EntireRow.Delete ' Next x it's effective, but takes a lot of time. Is there a faster method for this? thanks, Jake |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| For each cell method, is there a much faster way? | Excel Programming | |||
| Which method is faster | Excel Discussion (Misc queries) | |||
| Looking for faster method for Copy & Paste | Excel Programming | |||
| Which method is faster? | Excel Programming | |||
| Any delete rows macro faster than this one??? | Excel Programming | |||
Threaded Mode
