Hi,

I have a complex (and rather messy) formula in my spreadsheet which is used
in all rows. It works fine, no problem.

Is there any way of defining the formula once, elsewhere, perhaps in a
separate sheet, then 'calling' it in the main worksheet as if it were a
subroutine or sub-functtion.

I am thinking in terms of Basic programming, where there are subroutines &
subfunctions, but I dont know anything about VBA & prefer to avoid it.

Thanks for all ideas

KK