Blackie50
09-08-2010, 03:47 AM
HI
Just struggling with correct code for the following
If cells B20, B23 & B27 are empty then delete rows 12 to 29
If Range("B20").Value = "" And Range("B23").Value = "" And Range("B27").Value = "" Then
Rows("12:29").Select
Selection.Delete shift:=xlUp
End If
Tries several ways but it seems to skip over the condition - probably got it wrong
Any help appreciated
thanks
Just struggling with correct code for the following
If cells B20, B23 & B27 are empty then delete rows 12 to 29
If Range("B20").Value = "" And Range("B23").Value = "" And Range("B27").Value = "" Then
Rows("12:29").Select
Selection.Delete shift:=xlUp
End If
Tries several ways but it seems to skip over the condition - probably got it wrong
Any help appreciated
thanks