Why does this statement give an error message?
 

Good day,
Could you explain to me why the statement below should produce an error
message "VALUE!"

Range("M5").Value = 5

Thank you

George

Why does this statement give an error message?
 

Hello George,

A User Defined Function can only return a value that will be displayed
in the cell the UDF is in. You can not change the values of others
cells or their formats in a UDF. Calling a macro to chage a cell's
value or format from the UDF won't work either.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=513741

Why does this statement give an error message?
 

Leith, could you please explain your statement? My UDF is in the "Module1",
do you mean that I cannot change value of a cell from within the cell using
the statement below? If not, what should I do?

Kind regards
George

"Leith Ross" wrote:


Hello George,

A User Defined Function can only return a value that will be displayed
in the cell the UDF is in. You can not change the values of others
cells or their formats in a UDF. Calling a macro to chage a cell's
value or format from the UDF won't work either.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=513741