cannot find what is causing the bug

Hello unley,

I moved the macro [d]duedate[/b] into a standard VBA module. This can be run when the workbook opens. The changes have already been made to the attached workbook.

Module Code

Please Login or Register  to view this content.

Workbook Open Event Macro

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Change your This Workbook sub to

Please Login or Register  to view this content.

A V Veerkar

Thank you Leith Ross and avveerkar for quick reply.

avveerkar, there's no debug but the dates that are more than 11 months old did not highlighted in red (color 3)
After I deliberately add an older date like a year ago in E column, it supposed to highlight the this date in red when open the workbook next time but it did'nt. There must be a simple fix there somewhere.

Leith, there's a debug in Module that you've created and highlighted in yellow

Please Login or Register  to view this content.

It works fine when I deleted some spaces between codes

So thankyou both very much for your help. Cheers for now

Hello unley,

When using the SpecialCells method, you need to incorporate error handling in your code. More often than not, failure to find the cell type results in a error. I didn't think to add the error handler because the workbook you attached was blank.

Sincerely,
Leith Ross

Thank you for advice Leith but the workbook I attached is no blank otherwise how did you copy my codes?

Hello unley,

I meant there is no data on the worksheet for the macro to use.

Sincerely,
Leith Ross

Now that make sense. Thank you for useful added information. I'm still learning the hard way, cheers mate.