View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sharmashanu sharmashanu is offline
external usenet poster
 
Posts: 28
Default multiple if statement

Is there a better way to write these statements

If startb.Offset(i, 0).Value = "AC01" Then startb.Offset(i,
0).EntireRow.Delete
If startb.Offset(i, 0).Value = "AC03" Then startb.Offset(i,
0).EntireRow.Delete
If startb.Offset(i, 0).Value = "AC05" Then startb.Offset(i,
0).EntireRow.Delete
If startb.Offset(i, 0).Value = "AT01" Then startb.Offset(i,
0).EntireRow.Delete
If startb.Offset(i, 0).Value = "CF01" Then startb.Offset(i,
0).EntireRow.Delete
If startb.Offset(i, 0).Value = "CP01" Then startb.Offset(i,
0).EntireRow.Delete
If startb.Offset(i, 0).Value = "DB01" Then startb.Offset(i,
0).EntireRow.Delete
If startb.Offset(i, 0).Value = "DG" Then startb.Offset(i,
0).EntireRow.Delete
If startb.Offset(i, 0).Value = "DSK01" Then startb.Offset(i,
0).EntireRow.Delete
If startb.Offset(i, 0).Value = "FT080" Then startb.Offset(i,
0).EntireRow.Delete

thanks

Shanu