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!
|