I've defined a function as follows:
Function IsDataPoint(CellValue) As Boolean
If IsNumeric(CellValue) Then
IsDataPoint = True
ElseIf CellValue = "contact vendor" Then
IsDataPoint = False
ElseIf CellValue = "no quote, too thick" Then
IsDataPoint = False
Else
IsDataPoint = False
End If
End Function
I wrote the function in order to provide a flexible test for whether a certain value is a valid data point. At this time, we do not consider a value of "contact vendor" to be a valid data point, but at some time, we might. So I figured I would just use this function instead of the built-in isnumber function, and change the statements in the isdatapoint function according to whatever our latest definition of "data point" is.
But, Excel doesn't update the value returned by IsDataPoint when I change the code for the function -- unless I enter the formula window again and hit return. I've tried saving, closing and re-opening; there seems to be no easy automatic updating of the formula to reflect the new definition of the function.
Is there a workaround?
Thanks,
Rob
Function IsDataPoint(CellValue) As Boolean
If IsNumeric(CellValue) Then
IsDataPoint = True
ElseIf CellValue = "contact vendor" Then
IsDataPoint = False
ElseIf CellValue = "no quote, too thick" Then
IsDataPoint = False
Else
IsDataPoint = False
End If
End Function
I wrote the function in order to provide a flexible test for whether a certain value is a valid data point. At this time, we do not consider a value of "contact vendor" to be a valid data point, but at some time, we might. So I figured I would just use this function instead of the built-in isnumber function, and change the statements in the isdatapoint function according to whatever our latest definition of "data point" is.
But, Excel doesn't update the value returned by IsDataPoint when I change the code for the function -- unless I enter the formula window again and hit return. I've tried saving, closing and re-opening; there seems to be no easy automatic updating of the formula to reflect the new definition of the function.
Is there a workaround?
Thanks,
Rob