If and Or function

[washermann]

Hi I currently have an If function

If Cells(rowval, 2).Value = "Y" Then
[do this]
end If

But, now I want it so check

if the cell = "Y" or "y" or "1" Then
[do this]
End if


Is there any way to add this? I was reading up on the Or function but couldn't get it to work. Thanks

Figured it out

If Cells(rowval, 2).Value = "Y" or Cells(rowval, 2).Value = "y" Then
[do this]
end If

[leelnich]

Perhaps

Please Login or Register  to view this content.

The number 1 and text "1" would both read TRUE.

[leelnich]

Happy to help, thanks for the rep! If complete, please mark your thread as SOLVED (Thread Tools up top). Regards -Lee