View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] ronn2007@hotmail.co.uk is offline
external usenet poster
 
Posts: 3
Default User-defined type not defined

I am using this custom formula on a worksheet, and sometimes I get '
User-defined type not defined' error message. (However, the formula
works). How can I avoid this error?
Thanks!

Function SumActualPlusForecast(Y_Actual As Range, PeriodsRange As
Range, ValuesRange As Range, strThisYear As String) As Double

For iItem = 1 To 12
If Left(Trim(PeriodsRange.Cells.Item(iItem).Value), 4) =
strThisYear Then
intForecastTotal = intForecastTotal +
ValuesRange.Cells.Item(iItem).Value
End If
Next iItem

SumActualPlusForecast = Y_Actual + intForecastTotal

End Function