Auto fill cell range in multiple cell formulae

In a worksheet I have multiple cells using cell ranges to complete the calculations/formulae. eg "$B$40:$B$55000". I want the numeric values of the ranges to be changeable, by not having to go and e...