I will mention this tutorial I put together that doesn't use any VBA to use the NR algorithm: https://www.excelforum.com/tips-and-...ind-roots.html
If I understand what you are trying to do, arrange the calculation for a single incident of the NR algorithm in a single row/column (pay attention to relative and absolute references). Then, to repeat the calculation for other incidents, simply copy that row/column down/across.