clear cells in excel sheet using VB code

[kandyudayan]

Pls help

to make an if statement using vb code.
for example
If A1 = "January"
Delete cells ("B10:B15")
I like to make it till December (10 if statement) to delete different cells.

Thanks in advance

 

[MrKowz]

Try a Select Case statement:

Sub foo()
Select Case Range("A1").Value
    Case "January"
        'what to do for January
    Case "February"
        'what to do for February
    Case "March"
        'what to do for March
    'etc....
End Select
End Sub

 

[kandyudayan]

Thanks a Lot it works