I would like to change the range in the counfif-formula by using vba. By clicking a button the Range A3:A3 changes to A3:A4, then clicking the button again A3:A4 changes to A3:A5, and so on... I managed to create a constant vba-formula, but I do not know how to proceed. Anybody? :)

[Excel](https://i.stack.imgur.com/3VT8A.png)

[VBA](https://i.stack.imgur.com/IorDR.png)