title: Excel VBA to update cell values within table with variable number of columns
body: <p>I have a table of data which needs certain values to be changed based upon the value in column A.  The data resides in a column headed Analysis\xx where xx is a variable value from 1 to 60.  The number of columns varies per row, so that row 4 may go up to Analysis\4 whereas row 5 might go up to Analysis\30.  Every value appearing in the Analysis\xx field needs to be updated, where a certain value exists in column A. </p>
  
  <p>I have code to update values based upon a single fixed column position but I'm struggling to work out how to iterate through each row to update a variable number of columns.</p>
  
  <p>Any suggestions would be gratefully received. </p>
  
  <p>I've attached a sample of the data below which shows a good selection of the variation, with the columns that don't need amending hidden.  Row 26 actually goes all the way to column NB.</p>
  
  <p><a href="https://i.stack.imgur.com/tLEzy.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/tLEzy.png" alt="Data Sample"></a></p>