Macro works except for one cell

Attached workbook

I have a macro that works except for one cell (H24) which does not solve using Solver, the other 4 cells work fine. I have uploaded my Excel 2007 workbook. Any input/comments would be appreciated.

I’m no expert but I not sure if some of the code is needed. I have taken some of the fluff out already. I was wondering if we could make a small change as well. Right now when a number is entered in any one of the five cells (below) and the enter key is pressed the macro starts and the answer is produced. I was wondering if we could set up one cell to be used as a manual start button, if you will, to start the macro for all 5 cells.

I can post the code here if you like or please check my workbook.

This is what the macro should be doing:

1 - Search and determine which cells have numbers in the following cells: D24,F24,H24,J24,L24. There will always be numbers in 1 or all 5 cells.

2. For each found cell with a number the program does a calculation using Solver and then enters the answer in the cell below it. So as an example, for cell L24 (7.77 was entered) the answer (1.55) would be placed in cell L25.

Thank-you for all your help.

to attach a file.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

I need to delete the current workbook and upload the correct one could you assist.

Thanks

There are no macros in an xlsx file, Christine.

Christine, that looks like very convoluted code to so something that should be simple. Can you explain?

If you set a reference to Solver, your code can be simplified:

Please Login or Register  to view this content.

... except I don't understand the red part. You are setting B23 to Min while constraining B23 to ... what?

This doesn't make sense to me:

Solver – Set Target cell: $B$23
Equal To: Min Value of: 0
By changing cell $A$23
Subject to the constraints $B$23 = $C$23

You can set a cell to a given value or a minimum -- not both.

I don't grok what you're trying to calculate.

Glad you got it sorted, sorry I was useless.