| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
#REF! in while loop
dear all
i wrote a macro with a while clause, unfortunately there are also some rows which have #REF! and I want to delete them as well. How do I do it? last= 2011 Do While IsNumeric(ActiveSheet.Cells(i, 1).Value) And ActiveSheet.Cells(i, 1).Value last Dirk |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
#REF! in while loop
if iserror(Activesheet.Cells(i,1).value) then
' cell contains an error value -- Regards, Tom Ogilvy wrote in message ups.com... dear all i wrote a macro with a while clause, unfortunately there are also some rows which have #REF! and I want to delete them as well. How do I do it? last= 2011 Do While IsNumeric(ActiveSheet.Cells(i, 1).Value) And ActiveSheet.Cells(i, 1).Value last Dirk |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Advancing outer Loop Based on criteria of inner loop | Excel Programming | |||
| Loop Function unable to loop | Excel Programming | |||
| Problem adding charts using Do-Loop Until loop | Excel Programming | |||
| Worksheet_Change - loop within a loop | Excel Programming | |||
| HELP!!!! Can't stop a loop (NOT an infinite loop) | Excel Programming | |||
Linear Mode
