How do i write to cells in a function?

I can do it from a Macro but aparently not from a function. below I have included some code I was using to test this. any ideas what I can do to get it to work. This would be very useful to me in many aspects.

Please Login or Register  to view this content.

OK I had a feeling I was going to have to call a macro. but I wanted to check before I did that. Thanks.

Not sure if you've seen my edit, maybe it would help.

I was going to try to call a sub from the function. What do you think?

I've never tried that. Is that possible? :D

We will soon see.

nope cant do it

Cool I was unaware of that can you give me an example?

You can call a sub from a udf, but the same restrictions still apply -- the sub cannot alter the value of another cell like you are asking.

2 basic ideas I see for something like this:

1) Can you separate the logic for result A and result B? If you can separate the logic for the two results, then you put a function or code a separate udf to obtain result B and put that in cell B rather than having cell A/code A try to do both results.
2) If result A and result B are too closely interconnected to be separated, then you can write your udf as an array function and have it return both values. This looks like:

Please Login or Register  to view this content.

As with any of the built in array functions, the function has to be entered with cntrl-shift-enter, and the results are returned as an array (so typically they end up in adjacent cells). You can conceivably nest the udf inside the INDEX() function to return A or B, if desired.