Clear range contents instead

[kelly mort]

I want to clear the content from col B to N instead of deleting entire row.

I can't make it happen.

Can someone fix that for me?

I have tried

[COLOR=#A52A2A].Offset(1).EntireRow.ClearContents[/COLOR]

But did not work.

With Range("B3:N"& Range("B" & Rows.Count).End(xlUp).Row)
.AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:=[O1:O2], Unique:= False 
[COLOR=#a52a2a].Offset(1).EntireRow.Delete[/COLOR]

If .Parent.FilterMode Then .Parent.ShowAllData 

End With

 

[DanteAmor]

Try this

With Range("B3:N" & Range("B" & Rows.Count).End(xlUp).Row)
    .AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:=[O1:O2], Unique:=False
    .Offset(1).ClearContents
    If .Parent.FilterMode Then .Parent.ShowAllData
End With

 

[kelly mort]

Sure!!!

Problem solved.

Regards

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.