The following was meant:

In cell C10 and C11 are the values to which the range must be changed.
When e.g. in C10 is 25 and in C11 is 35 the the range should be 
ActiveCell.Formula = "=sum(A25:A35)"
Is this possible to change this formula acordingly or is there another solution e.g. a UDF?