Hi, this gotta be something very simple that I'm missing. The
following function is inside a module and it fails on Worksheet ...
statement. The function returns #value

Function ddddd(X As Double) As Double

Worksheets("Sheet1").Range("A1").Value = 123

ddddd = X + 1

End Function

Also Worksheets("Sheet1").Cells(1,1).Value = 123 fails in the same
manner

Thank you!

Remove the

Worksheets("Sheet1").Range("A1").Value = 123

A UDF cannot do anything other than return a value to the cell it's in.

--
Jim
<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
| Hi, this gotta be something very simple that I'm missing. The
| following function is inside a module and it fails on Worksheet ...
| statement. The function returns #value
|
| Function ddddd(X As Double) As Double
|
| Worksheets("Sheet1").Range("A1").Value = 123
|
| ddddd = X + 1
|
| End Function
|
| Also Worksheets("Sheet1").Cells(1,1).Value = 123 fails in the same
| manner
|
| Thank you!
|

"Jim Rech" wrote:

> A UDF cannot do anything other than return a value to the cell it's in.
>
> --
> Jim

True. Also, no formatting can be done. What I found a bit strange when I saw
it, is that a UDF can produce a MsgBox.

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music

>>a UDF can produce a MsgBox

True enough. It just cannot 'do' anything to a workbook itself.

--
Jim
"Wigi" <(E-Mail Removed)> wrote in message
news:C6731256-C532-477A-907E-(E-Mail Removed)...
| "Jim Rech" wrote:
|
| > A UDF cannot do anything other than return a value to the cell it's in.
| >
| > --
| > Jim
|
| True. Also, no formatting can be done. What I found a bit strange when I
saw
| it, is that a UDF can produce a MsgBox.
|
| --
| Wigi
| http://www.wimgielis.be = Excel/VBA, soccer and music
|
|
|