Hi,

I have the following triggered by a worksheet change (there's some other
stuff before this line, but that's all working) which causes an error:

Case Is = "Open"
Range("a" & Target.Row & ":ac" & Target.Row).Select
With Selection.Interior
.ColorIndex = xlNone
End With
Range("o" & Target.Row & ":q," & Target.Row & "t" &
Target.Row_ & ":v," & Target.Row & "z" & Target.Row & ":ab" &
Target.Row).Select
With Selection
.Value = ""
End With
End Select

The error is being generated at the line Range("o" & Target.Row & <etc etc)
and is "Run-time error 1004: Method 'Range' of object '_Worksheet' failed

Can someone please tell me what tis means and how I fix it?

TIA

Dave