S B S

123832 521

123833 S45

123834 354

123835 S21 123838 S4S 123837 S54

I D | £ | F | 0 | :■ CuaLwnfliNumbm F'lflJuclHartnui WreiRhtiM PlfltfuetCflit

txfa, -wjr i, iffsea

CflMfi 0SSOO D 4ME31

C7366 100CC M -

7:c a keki

You can also have a For...Next loop run backward from high to low. This is particularly useful if you are selectively deleting rows. To do this, reverse the order of the For statement and have the Step clause specify a negative number:

' Delete all rows where column C is the Internal rep - C54 FinalRow = Cells(65536, 1).end(xlup).row For I = FinalRow to 2 Step -1

Cells(I, 1).EntireRow.Delete End If Next i

0 0

Post a comment