slotcardan
Technical User
I have been using "backsolve" to calculate some engineering flow rates. I have columns about 25 rows deep. I am trying to backsolve for all of these cells. The macro I wrote simply goes down all 25 cells, backsolves and places the result in a cell next to them. The problem I have is backsolve does not work on three of the 25 cells. I have tried putting numbers without decimal places and just about anything else. Backsolve will not solve these seemingly simple calculations. When I click OK to accept the best available solution its not even close. Anyone have any suggestions??????
Dan R
Dan R