Function with results in offset cell

[Andibevan]

Is it possible to build a function that will place one half of the result in
the active cell (as normal - cell where the formula is) and another part of
the result in the cell to the right of the active one?

Something like this (which doesn't work incidentally):-

Function testoff(var)
testoff = var + 10
ActiveCell.Offset(1, 1).Value = 1


End Function

[Norman Jones]

Hi Andi,

If your intentention is to use the function in a worksheet, this is not
possible as a udf can only return a value to the calling cell.

---
Regards,
Norman



"Andibevan" <[email protected]> wrote in message
news:[email protected]...
> Is it possible to build a function that will place one half of the result
> in
> the active cell (as normal - cell where the formula is) and another part
> of
> the result in the cell to the right of the active one?
>
> Something like this (which doesn't work incidentally):-
>
> Function testoff(var)
> testoff = var + 10
> ActiveCell.Offset(1, 1).Value = 1
>
>
> End Function
>
>

[Andibevan]

Thought so - just was hoping...

Thanks

"Norman Jones" <[email protected]> wrote in message
news:[email protected]...
Hi Andi,

If your intentention is to use the function in a worksheet, this is not
possible as a udf can only return a value to the calling cell.

---
Regards,
Norman



"Andibevan" <[email protected]> wrote in message
news:[email protected]...
> Is it possible to build a function that will place one half of the result
> in
> the active cell (as normal - cell where the formula is) and another part
> of
> the result in the cell to the right of the active one?
>
> Something like this (which doesn't work incidentally):-
>
> Function testoff(var)
> testoff = var + 10
> ActiveCell.Offset(1, 1).Value = 1
>
>
> End Function
>
>