Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi, not sure if a problem (application was closing till fixed trick on if:
NOT(isnumber, then (isnumber.. ), have equation for entering text date in cell form as: :yymmdd formula is for conditional format if within x days, when put formula in external cell to edit, / verify I get #value errors, they seem to be because I do not have a date in the source cell. do I disregard error? I added an item to show: if <1.. and no date, then true. date entered, in or out of range = ok true / false. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Ignore error msgs in formula references | Excel Discussion (Misc queries) | |||
Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) | |||
Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) | |||
Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
ERROR | Excel Discussion (Misc queries) |