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]

Welcome to the board. Your query is not clear at all so making a guess as to what you are asking. I think you want the code changed to:

If Range("C" & CStr(LSearchRow)).Value = "PS MOP" Or Range("C" & CStr(LSearchRow)).Value = "PG MOP" Then
  If Range("F" & CStr(LSearchRow)).Value >= DateSerial(2012, 10, 1) AND Range("F" & CStr(LSearchRow)).Value <= DateSerial(2012, 10, 31) Then
     ' Something your code should do
  End If
End If

If you want Range F to be directed to a specific cell, you should use Range("B3"), changing B3 to whatever address you are trying to direct to

 

[Kflamme20]

Welcome to the board. Your query is not clear at all so making a guess as to what you are asking. I think you want the code changed to:

If Range("C" & CStr(LSearchRow)).Value = "PS MOP" Or Range("C" & CStr(LSearchRow)).Value = "PG MOP" Then
  If Range("F" & CStr(LSearchRow)).Value >= DateSerial(2012, 10, 1) AND Range("F" & CStr(LSearchRow)).Value <= DateSerial(2012, 10, 31) Then
     ' Something your code should do
  End If
End If

If you want Range F to be directed to a specific cell, you should use Range("B3"), changing B3 to whatever address you are trying to direct to

Thank you, I think "Or" would function in that manner. As for DateSerial, it works even with double If, I just meant to mention a cell in a worksheet with current date io changing constantly the dates by hand each month.

 

[Norie]

What do you mean that it has 2 values?

 

[Kflamme20]

What do you mean that it has 2 values?

By two values I mean "PS MOP" and "PG MOP"

 

[Norie]

What exactly is in the cell(s)?

 

[Kflamme20]

What exactly is in the cell(s)?

I don't want to change the date manually, I'd like to put it in a cell and make reference in the macro to that cell.
The result must meet two values in a range, either PS or PG and not just one.

 

[Norie]

Sorry, I thought you said there were two values in the cell?

Are you now saying there are 2 possible values in the cell?

What exactly is the logic of the code?

 

[JackDanIce]

Norie, he's not being very clear, I think he's asking for a macro to act IF a cell in column C is either value "PS MOP" or "PG MOP" and the date in the equivalent row in column F lies between a date range.

The date range is currently hardcoded in the macro code and he wants to change this, so the code references a cell that contains the date, which means later, he can change the date on the worksheet without needing to update the macro code itself. I think that's what he's after anyway, could be very wrong!

Kflamme - the more clear and precise you can be, easier it is to answer

 

[Kflamme20]

Norie, he's not being very clear, I think he's asking for a macro to act IF a cell in column C is either value "PS MOP" or "PG MOP" and the date in the equivalent row in column F lies between a date range.

The date range is currently hardcoded in the macro code and he wants to change this, so the code references a cell that contains the date, which means later, he can change the date on the worksheet without needing to update the macro code itself. I think that's what he's after anyway, could be very wrong!

Kflamme - the more clear and precise you can be, easier it is to answer

You're quite right as to the date, but not as to other values.