Cannot change Cell value
 

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!

Cannot change Cell value
 

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
wrote in message
ps.com...
| 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!
|

Cannot change Cell value
 

"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

Cannot change Cell value
 

a UDF can produce a MsgBox

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

--
Jim
"Wigi" wrote in message
...
| "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
|
|
|