Macro variations

[Kflamme20]

Hello, guys!
I've got a couple of issues. There's the line in the macro which goes

If Range("C" & CStr(LSearchRow)).Value = "PS MOP" Then
If Range("C" & CStr(LSearchRow)).Value = "PG MOP" Then
If Range("F" & CStr(LSearchRow)).Value >= DateSerial(2012, 10, 1) Then
If Range("F" & CStr(LSearchRow)).Value <= DateSerial(2012, 10, 31) Then

but it doesn't function, because Range C has two values. I tried it with a "*", still doesn't function.

1). Is there a way to unite a couple of values in Range C
2). and can Range F be directed to a certain cell in a worksheet?

Thanks.

 

[JackDanIce]

Hello, guys!
I've got a couple of issues. There's the line in the macro which goes

If Range("C" & CStr(LSearchRow)).Value = "PS MOP" Then
If Range("C" & CStr(LSearchRow)).Value = "PG MOP" Then

What values if not PS MOP and PG MOP? Your reply wasn't particularly clear or precise..