vba using the OR operator
Should it not be:
If Cells(iRow, 1).Value
RBS
"Mona" wrote in message
...
Thank you Vergel for reply but I am getting error on this code:
If Rows(iRow, 1).Value = "11/13/2005" Or Rows(iRow, 1).Value =
"11/23/2005"
Then
**code**
end if
"Vergel Adriano" wrote:
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!!
|