vba using the OR operator
Monda,
Try it this way:
If Rows(iRow,1).value = #11/13/2005# or Rows(iRow,1).value = #11/23/2005" Then
'* YOUR CODE HERE *
End if
"Mona" wrote:
Here is my code that does not work:
If Rows(iRow, 1) = ("11/13/2005" Or "11/23/2005") Then
blah blah
I can get the code to work on a single date but not with multiple dates
using "or". I have about 20 dates that I want to check and I could get by
with just repeating the code 20 times but I wanted to do it using a single
statement.
Thank you!!
|