Macro to Clear Cells based on Criteria

[jawaharprm]

Hi All,

Pls help to get this macro
from ("C:N") cells should be clear
if in column "B" Criteria meets "ST"
reference file enclosed

Thanks
Jawahar

 

[vletm]

jawaharprm
Ask an Excel Question and Macro to Clear Cells based on Criteria ... won't match.
This thread has moved to VBA Macros

 

[AlanSidman]

Option Explicit

Sub foo()
    Dim lr As Long, i As Long
    lr = Range("A" & Rows.Count).End(xlUp).Row
    For i = 5 To lr
        If Range("B" & i) = "ST" Then Range("C" & i & ":N" & i).ClearContents
    Next i
End Sub

 

[vletm]

jawaharprm
Your Keywords were clear & meets.

 

[jawaharprm]

Hi Sir,
Thanks its working fine, Sorry for uploading in wrong criteria..

 

[vletm]

jawaharprm
You can change Your ST-criteria Yourself.