I'm trying my hand in UDFs. In practice I created the following UDF in a
module

Function Area(Length As Double, Width As Double)
Area = Length * Width
End Function

Back in work book, I type =Area(A1,B1) in cell C1.

The result shown in the cell is 0. The result shown from the formula
dialogue box is 24. I have no idea what's going on. Any help is sppreciated.