I am just starting learning VBA, so I am doing some nice easy examples such as the function below. I got =area(#,#) working, but =area(#) is returning #VALUE!. Thoughts?
Function Area(Length As Double, Width As Double)
If IsMissing(Width) Then
Area = Length * Length
Else
Area = Width * Length
End If
End Function
Bookmarks