Macro to check date range against criteria

[tariqfaiyaz]

I need VBA code to check each weekday date in a date range against a table in another sheet, if the corresponding value is >9% for any of the days, it should return a msg box

i.e, in the "Leave Request Template", the code should check each of the weekdays for the range given in B7 and B9, against the "Master" worksheet in "Leave Tracker Master" sheet, if the corresponding value for any one date in the "Total" column is >9%, it should return a msg box

[tariqfaiyaz]

I wrote this code for the check, but it returns a type mismatch error, can someone help?? I get the type mismatch error in this line

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[tariqfaiyaz]

I even tried

Please Login or Register  to view this content.

this doesn't give an error but it doesn't perform the check and runs the rest of the macro, someone help me please, I'm just a beginner and am going crazy trying to figure this out !!

[tariqfaiyaz]

Figured it out !!! It was returning an error

Please Login or Register  to view this content.