Worksheet Functions that Change Other Cells
 

Nope there is no way around it. A function called within a worksheet can not
change the contents of other cells. The only exception that I know of is that
it can change the contents of a comment for another cell.
--
HTH...

Jim Thomlinson


"Robert Mulroney" wrote:


There seems to be some kind of security that prevents a function called from
a worksheet changing other cells (on that sheet or anyother). Is there anyway
to get around that? I'm hopeing to update a range of cells when the sheet
calculates without using the "onCalcluate" event.

In fact I know that it's possible because I use a thrid party product that
does just this. How it does it is somewhat of a mistery to all of us.

To hopefully make myself clearer if I call this function:

Public Function timesTheyAreAChanging() As String
timesTheyAreAChanging = "Time"
Range("A3") = Now()
End Function

From a worksheet using:

"=timesTheyAreAChanging()"

then it returns an error result.

Yet if I comment-out the line that changes another cell then it works fine.
This is obviously a simple example what I want to do is much more complex but
the problem remains the same.


- Rm