I have (for me) a big problem. In the attached document I have a formula in cell D7. D7 links to cell A7:A9. And it works. Now I want that I can do the same thing in VBA but the result should be in cell D1. D1 links to cell A1:A3.
I have made the formula in cell D7 to explain what it is I want . I'm not going to use that one in the future but only the VBA code.
Please someone help me.