Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
while deleting rows it finds an error - error trapping
Okay, my code seems to be working but it stops after deleting the first two
rows. It must find an error then return to 0 but what is the error? The only thing I see is there are two cells together in column M that are blank. There are a whold bunch more. HOw do I trap for the error so this script will finish. thanks, sorry for the multiple posts. -----------code------ Sub DeleteRowsBlankMColumns() With ActiveSheet On Error Resume Next .Columns("M").SpecialCells(xlCellTypeBlanks).Entir eRow.Delete On Error GoTo 0 End With End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting a range of rows based on a variable; syntax error | Excel Discussion (Misc queries) | |||
runtime 1004 error on deleting rows with blank cells | Excel Programming | |||
Error when deleting rows | Excel Programming | |||
Code deleting all rows in error | Excel Programming | |||
Deleting rows based upon Error conditions | Excel Programming |