Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
for each c in range.. how set counter "minus 1"?
Hi.
In my code, I delete the entire row of a particolar cell 'c' (if tel = c). However, the loop "next c" jump to next one, but the real new 'c' is in the same row, because actual 'c' in same row is deleted. How can set c counter minus 1? [...] For Each c In Range("F:F") If tel = c Then Rows((c.Row)).Delete End If End If Next c [...] Thanks to all M. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I set up a "roll over" counter in excel 2003? | Excel Worksheet Functions | |||
multiple file uploading - runtime error'13': type mismatch "While Counter <= UBound(FName)" | Excel Discussion (Misc queries) | |||
use variable in Workbooks("book1").Worksheets("sheet1").Range("a1" | Excel Programming | |||
Using "Cells" to write "Range("A:A,H:H").Select" | Excel Programming |