I have a line of code to take a cell that is populated with a date and add 760 (two years):
I keep getting Type Mismatch, presumably on account of adding a number to the date - but how can I get around this? "OneMonth" is a named cell with another date in it
Code:
If Cell.Value + 730 > Range("OneMonth").Value Then
Cell.Interior.ColorIndex = 44
I keep getting Type Mismatch, presumably on account of adding a number to the date - but how can I get around this? "OneMonth" is a named cell with another date in it