Error when trying to use code that works in Excel 2007 to 2010

Last edited by marreco; 11-23-2012 at 10:38 AM.

"No xadrez nem sempre a menor dist?ncia entre dois pontos ? uma linha reta" G. Kasparov.

If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select b from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.

"Unless otherwise stated all my comments are directed at OP"

Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code

how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito

how to say no convincingly

most important thing you need
Martin Wilson: SPV
and RSMBC