S
Suzie
Hi - I have to do an assignment which involves writing a function macro.
This is what I have written:
Sub Review()
Function Review(Overall As Single, recent As Single) As String
If recent >= 4 Then
Good&
Else
Poor&
End If
If recent >= Overall Then
Improving&
Else
Interview&
End If
Review = recent & Overall
Range("E8").Select
End Function
End Sub
Now I don't know much about vba and I'm having trouble making this work.
Would some kind person out there be able to explain to me where I am going
wrong? The message that I keep getting is that Review is too ambiguous !!
I would very much appreciated any help at all.
Thank you
Suzie
This is what I have written:
Sub Review()
Function Review(Overall As Single, recent As Single) As String
If recent >= 4 Then
Good&
Else
Poor&
End If
If recent >= Overall Then
Improving&
Else
Interview&
End If
Review = recent & Overall
Range("E8").Select
End Function
End Sub
Now I don't know much about vba and I'm having trouble making this work.
Would some kind person out there be able to explain to me where I am going
wrong? The message that I keep getting is that Review is too ambiguous !!
I would very much appreciated any help at all.
Thank you
Suzie