Somewhere in a redesign of my project I decided that I wanted to chang
all cell values at once. Didn't work. Simplifying led me to th
following problem:

New workbook, new function:


Code
-------------------
Function testThisThen()

Worksheets("sheets1").Range("B5").Value = 20

end Functio
-------------------

Now I want to execute this code from a cell like so:
=testThisThen()

Won't work.
As I just tested this I discovered the 'play button' in the VB editor
Pressing it will properly execute the code.
Calling the function from the cell, however, leads to problems with th
.Value = 20 statement.
This code:

Code
-------------------
Function testThisThen()

On Error Resume Next
Worksheets("sheets1").Range("B5").Value = 20
testThisThen = 12

end Functio
-------------------

will change the value of the cell which calls the function to 12, bu
won't change the value of B5.

Is it possible to change the value of a cell this way? I require som
additional arguments to be used in the function, hence the desire t
use a formula in a cell.

I was unable to find an answer to this question; searching for '.Value
and 'doens't work' will not give very good searchresults though, so m
apologies if this has been answered once already

--
Danybo
-----------------------------------------------------------------------
Danyboy's Profile: http://www.excelforum.com/member.php...fo&userid=2609
View this thread: http://www.excelforum.com/showthread.php?threadid=39422