I am having problem with macros in Excel 2007. I created the following macro: If Range ( "M10") = 2 Then Range ( "K20"). Copy Range ( "D3") This little function allows me to paste the contents of the cell K20 in a table cell D3.

So far, no problem. The concern is that I wanted the cell K20 corresponds to the sum of cells M17 + M18 + M19. And there, it's corse. Excel installation error # REF! from the time when the formula contains a sum.

For the moment, so I have to manually enter the number 9 (sum of M17-18-19) for example, so that the button on the copy which I support in cell D3.

Can anyone know tips to do this ?

Thanks

## Bookmarks