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!!