VBA – Update Other Cells via User-Defined Function
Here is a way you can circumvent the restraint, you must do it indirectly. Method copied from Excel – How to fill cells from User Defined Function?: In a standard module: Public triggger As Boolean Public carryover As Variant Function reallysimple(r As Range) As Variant triggger = True reallysimple = r.Value carryover = r.Value / … Read more