Jim,

Does wrapping the UDF in VBA also give it the ability to do whatever it wants?

Would an RTD server also be able to do whatever it wants?

Thanks

Michael
"Jim Thomlinson" wrote:

The question is how is the function called.
If the function is called by adding a formula to a cell then it can only
modify the value of the cell that it is in. Similar to any function in XL
such as sum or average it's scope is limited to the cell that it is in.
If however the function is called using a command button or event then a
function has free reign to do whatever it wants to any number of cells in any
number of sheets.
--
HTH...

Jim Thomlinson