Hi,
I am currently using the below code to calculate number of conditionally formatted cells with dates in. I am needing to use this macro over three sheets in the workbook. It is currently only displaying data on one sheet at a time. If I have two books open at the same time running the same macro it will also only calculates on one sheet. I have no idea how to fix this and really hoping someone is able to help.
I am needing the end user to be able to just enter a date and it will conditionally format and then be calculated but the macro automatically. this is Monitoring dates that have expired or in date.
Bookmarks