Here's my code:
And the error: Unable to get the Min property of the WorksheetFunction class"
Now, here's the weird thing. I did not have this problem yesterday. I admit that a lot has happened to the worksheet in the itnerim, but I'm pretty sure the WorksheetFunction class had a Min property before I went to sleep last night.
...so maybe the idea is that the property exists, but it's not working? Here's the only factor I can think of. The column that I am trying to get the minimum date for contains formulas (to create that date based on data in other cells). Ergo, some of the cells in columns O and P have formulas in them which are currently yielding "#VALUE!" because they have no data to draw from. Is this the problem? And, er, what should I do about it?
Thanks...
Code:
If Target.Column = Range("E:E").Column Then
lblOverallFltStart.Caption = "" & Format(Application.WorksheetFunction.Min(Range("O:O")), "mm/dd/yy")
End If
If Target.Column = Range("E:E").Column Then
lblOverallFltEnd.Caption = "" & Format(Application.WorksheetFunction.Max(Range("P:P")), "mm/dd/yy")
End If
And the error: Unable to get the Min property of the WorksheetFunction class"
Now, here's the weird thing. I did not have this problem yesterday. I admit that a lot has happened to the worksheet in the itnerim, but I'm pretty sure the WorksheetFunction class had a Min property before I went to sleep last night.
...so maybe the idea is that the property exists, but it's not working? Here's the only factor I can think of. The column that I am trying to get the minimum date for contains formulas (to create that date based on data in other cells). Ergo, some of the cells in columns O and P have formulas in them which are currently yielding "#VALUE!" because they have no data to draw from. Is this the problem? And, er, what should I do about it?
Thanks...