View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] brains4math@gmail.com is offline
external usenet poster
 
Posts: 1
Default 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!