12 Tem 2017 ... To automate godl-seeking, write a VBA macro, not a UDF. A macro can automate goal-seeking on any range or set of cells.