Home |
Search |
Today's Posts |
#5
![]() |
|||
|
|||
![]()
Your worksheet function I'll not modify.
I give you the VBA function to judge if it is a date. If it is a date, it will return true, otherwise it will return false. The function DateJudge have 2 parametres ra is a cell address, iyear is a condition that you can modify when the year =iyear, it can be recognized as a date. Function DateJudge(ra As Range, iyear As Integer) DateJudge = False If IsDate(ra) Then If Year(ra) = iyear Then DateJudge = True End If End Function |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Unintended line connecting two data points | Charts and Charting in Excel | |||
unintended format changes Excel 2007 | Excel Discussion (Misc queries) | |||
Hiding a button when hiding rows | Excel Discussion (Misc queries) | |||
Hiding Column Also hiding text | Excel Programming | |||
#DIV/0! hiding | Excel Discussion (Misc queries) |