title: Select column 1 to 10 of ActiveCell row in Excel
body: <p>this is regarding a macro in an excel. </p>
  
  <p>While a combination of keys are pressed (i.e. the macro is triggered), I need to do some format changes to the columns 1 to 10 of the row that has the ActiveCell. </p>
  
  <p>At the moment I have am selecting the entire row</p>
  
  <pre><code>ActiveCell.EntireRow.Select
  </code></pre>
  
  <p>However, I need to select only the row 1 to 10. I think it ought to be something like </p>
  
  <pre><code>ActiveCell.Range(1, 10).Select
  </code></pre>
  
  <p>But that does not work. </p>
  
  <p>Just to be clear, I have read about </p>
  
  <pre><code>ActiveCell.Offset(5, -4).Select
  </code></pre>
  
  <p>But that is not going to work in my case. The ActiveCell could be any column of the row and hence a hardcoded offset is not going to help. </p>
  
  <p>So, the excel gurus there, I am hoping this is a quick stuff, just that somehow I can't find the answer. Please help. </p>