See http://tinyurl.com/holx5, thread item #9

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Hervinder" wrote in message
...
I have a maths problem which i am trying to solve with a macro.

I have a list of numberin column A such as

12
14
45
24
85
78
5
33

If i have a value lets say 62 which is the sum of two or more values in
the
list i would like the macro to place a formula under the list of values
adding the cells which make up that total.

62 is made of 33+5+24 this would be formula i would want placed under the
list.

Any suggestions?