Hi.
I have a cell containing an external link, eg stock value.
I wish to write a function that will update several cells (among other jobs) that is called when my original cell changes.
eg
cell a1 contains stock price.
cell a2 contains =myfunc(a1)
If myfunc returns a value that is put into A2, but I cannot make a call to
ActiveWorkbook.Sheets("SHEET1").range("c3").value = 10.
from within my function.
the funciton header is
Public Function myfunc(mcell As Integer) As Variant
This works when called with a fixed number, and I am sure I can get it to work when called with a cell ref, but I cannot update a third cell from this function. Is there any way?
Thanks
I have a cell containing an external link, eg stock value.
I wish to write a function that will update several cells (among other jobs) that is called when my original cell changes.
eg
cell a1 contains stock price.
cell a2 contains =myfunc(a1)
If myfunc returns a value that is put into A2, but I cannot make a call to
ActiveWorkbook.Sheets("SHEET1").range("c3").value = 10.
from within my function.
the funciton header is
Public Function myfunc(mcell As Integer) As Variant
This works when called with a fixed number, and I am sure I can get it to work when called with a cell ref, but I cannot update a third cell from this function. Is there any way?
Thanks