Change formulas to variable row in range
 

Hello,

I have a range that contains formula's like the one below
=SUMPRODUCT((LEFT($A$4:$A41,1)="1")*H$4:H41)
pulling results from a list

The problem I have is that after the macro runs, I want to change the
bottom row in the range from 41 to the new bottom which is variable.

Is there an easy way to update my formulas with the new bottom number?

Your help is appreciated

Glen