VBA for Monday

[zyhin]

Hi all,

can someone tell me if this is right. I dont know where I am going wrong as this is not working for me

IF Date = vbMonday Then
    'My code
End If

 

[Rick Rothstein]

The built-in constant vbMonday evaluates to the number 2 where as Date will never be that small a number. I think you are looking for this...

If Weekday(Date) = vbMonday Then

 

[zyhin]

Thanks! That part of the code is now working smoothly.