View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] bbcdancer@hotmail.com is offline
external usenet poster
 
Posts: 15
Default Excel VBA OR statement

Why does the OrRstatement for "y" does not work?

Private Sub Worksheet_Change(ByVal Target As Excel.Range)

If Target.Column = 3 Then

If (Target.Text = "Y" Or "y") Then

Target.Offset(0, 1).FormulaR1C1 = Now()
Target.Offset(0, 2).Interior.ColorIndex = 5
Target.Offset(0, 3).Interior.ColorIndex = 4

End If
End If

End Sub