title: Dynamic ranges in Excel
body: <p>I have the cells <code>$A$4:$J$13</code> defined as <code>myRange</code>.  I would like to be able to put the sum of the values in column <code>H</code> within <code>myRange</code> (i.e. <code>$H$4:$$13</code>) in cell <code>$H$3</code>.  I know that <code>=SUM(OFFSET(myRange,0,7,10,1))</code> will do the trick until…. The user inserts a row(s) or column(s) within <code>myRange</code>.  The 7 columns over and 10 rows deep are not updated.  Is there a way to dynamically specify the boundaries of the cells I wish to sum?</p>