title: Set range based content locations
body: <p>Hope someone can help, I have a sheet I need to set a dynamic range to then do a looping function populating calculations against the correct variable.</p>
  
  <p>For example I have a list of headers</p>
  
  <p>Operator Name       -      Round Count      -    Cost</p>
  
  <p>Bob</p>
  
  <p>Ted</p>
  
  <p>Fred</p>
  
  <p>For the above example I want to find Operator Name and set it as the starting range then Select - End(xlToRight) &amp; End(xlDown) then my current code loops through all of the Operator names (Bob, Ted &amp; Fred) and inputs values in Round Count and Cost base on what is calculated.</p>
  
  <p>The issue I have is that The first cell may not always be in the same location e.g.  Operator name on one sheet may be in Cell F100 and on the next F134. I was thinking of doing a Find and setting that as the starting cell but Operator name appears a number of times throughout the sheet.</p>
  
  <p>Anyone have a similar problem they've solved or can someone suggest something?</p>