ExcelBanter - View Single Post - Checking when target.values are empty. What am I doing wrong?

Barb Reinhardt

I have the following code

If Target.Offset(0, 0).Value Target.Offset(-1, 0).Value And _
Target.Value Is Not Empty And _
Target.Offset(0, 1).Value Is Not Empty And _
Target.Offset(0, 2).Value Is Not Empty And _
Target.Offset(0, 3).Value Is Not Empty And _
Target.Offset(0, 4).Value Is Not Empty And _
Target.Offset(0, 5).Value Is Not Empty And _
Target.Offset(0, 6).Value Is Not Empty Then