bobby_smith
Board Regular
- Joined
- Apr 16, 2014
- Messages
- 90
Hi Guys,
I'm trying to use some defined functions that I created back in 2014 which worked perfectly then (its been about 2 years since I used it).
Now when I use it, I get the message "Compile error: Cant find project or library.
One of the function uses format and the other use Left
In the function below, I would type =GO( ) select a cell and the result should be for example GO09.
Function GO(number) As String
GO = "GO" & Format(number, "0#")
For the one below, I would type =Fasmonths( ) select a cell and the number should be converted to months.
Function FasMonths(Estimated_Life)
If Estimated_Life < 13 Then
FasMonths = Estimated_Life
ElseIf Estimated_Life > 12 Then
FasMonths = Left(Estimated_Life, Len(Estimated_Life) - 2) * 12 + Right(Estimated_Life, 2)
End If
End Function
I'm trying to use some defined functions that I created back in 2014 which worked perfectly then (its been about 2 years since I used it).
Now when I use it, I get the message "Compile error: Cant find project or library.
One of the function uses format and the other use Left
In the function below, I would type =GO( ) select a cell and the result should be for example GO09.
Function GO(number) As String
GO = "GO" & Format(number, "0#")
For the one below, I would type =Fasmonths( ) select a cell and the number should be converted to months.
Function FasMonths(Estimated_Life)
If Estimated_Life < 13 Then
FasMonths = Estimated_Life
ElseIf Estimated_Life > 12 Then
FasMonths = Left(Estimated_Life, Len(Estimated_Life) - 2) * 12 + Right(Estimated_Life, 2)
End If
End Function