Call Sub from Function?
 

Is it possible, and if so, what is the syntax? I set up a simple test case,
and the sub call executes correctly when I step through the function but
does not work when the function is put into a cell formula.

Thanks,
George

Call Sub from Function?
 

Hello George,

If you are creating a User Defined Function (UDF) to work as a
worksheet formula, the first rule is you can not modify another cell on
the worksheet. You may look but not touch. If your Sub is modifiying a
cell, that's the problem. You can change a cell in VBA on the worksheet
with no problem, but you can't change a cell on the worksheet if the
function is a UDF.

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=487522