Is there any way of making duedate works with the cells that has forumlas?
In range D2:D7 there are formulas with dates where message should return saying please check the date which is overdue but the codes does not work
In range D8:D11, these dates are normal without formulas and works with the code
DueDateFail.xls
If I change the code in Sheet1 to D2:D7 the codes won't work but do work with D8:D11 because the dates in D8:D11 don't have the formulas like D2:D7 has
Thanks
Last edited by unley; 10-13-2009 at 08:51 PM.
Hi,
Change
to
For Each Cell In Range("d2:d11").SpecialCells(xlCellTypeConstants)
and your code should work. Cells contain fomula will not be evaluated if you use SpecialCells(xlCellTypeConstants)For Each Cell In Range("d2:d11")
Tony
Yep, that fixed it alright. My, I always learn the hard way.
Thank you TonyS for your time, much appreciated
Cheers mate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks