I use Harlan Grove's code as posted by Norman but here is another
alternative...

http://www.tushar-mehta.com/excel/te...olver_Template

--
HTH...

Jim Thomlinson


"tdub" wrote:

I have a string of dollar amounts and I am trying to see if there is a quick
way to find out what amounts will total a fixed number. For example, I have
a number of cells, and I want to see what cells will total $500,000.00