Macro with DATE

[flamme20]

In my macro I try to apply the following conditions:

If Range("A" & CStr(LSearchRow)).Value = "ST" Then
If Range("K" & CStr(LSearchRow)).Value = "export" Then
If Range("B" & CStr(LSearchRow)).Value >= "DATE(2011,8,1)" Then
If Range("B" & CStr(LSearchRow)).Value <= "DATE(2011,8,31)" Then

The first two work fine, but I can't figure out the date parameter. How can I make it work?
I may have the first date of the month and the last mentioned on the target sheet.

 

[VoG]

Try like this

If Range("B" & CStr(LSearchRow)).Value >= DateSerial(2011, 8, 1) Then

 

[flamme20]

Thanks, that works fine.

Try like this

If Range("B" & CStr(LSearchRow)).Value >= DateSerial(2011, 8, 1) Then