Can I create an If condition with multiple Then (consequences) ?

So the title is pretty self explanatory but... Is it possible for me to create a code in my worksheet with an If condition with several Then statements?
Kind of like what I am trying to do here... (code is in a worksheet called CAPA)
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = Me.Range("G9").Address Then
If Target.Value = "" Then
Sheets("%Humidade NLT 102 91").Visible = False
Sheets("RESUMO").Column("9").Visible = False
Else
Sheets("%Humidade NLT 102 91").Visible = True
Sheets("RESUMO").Column("9").Visible = True
End If
End If

But it bugs on the Sheets("RESUMO").Column("9").Visible = False part, saying ''Object doesn't support this property or method"
Helppppp

Thank you but I tried your code and it bugs, the pop up says "aplication defined or object defined error"...

Originally Posted by Vikas_Gautam

Actually The column property returns the column Num not the column itself..
You have to use columns property... to refer a column...

and for multiple conditions use AND and OR statements..

here is the revised code..

Please Login or Register  to view this content.