title: Setting up a macro that will format a row from active cell
body: <p>I am trying to create a macro that will format a row. I can make one that formats a specific range, but I am wondering how to format according to the row that I have selected. </p>
  
  <p>I haven't really tried that much because I am extremely beginner to this and wasn't really sure where to start. I didn't want to pull my hair out trying random things. I am barely a coder and simply don't know anyone who can help me out. </p>
  
  <pre><code>Range("D131").Select
  ActiveCell.FormulaR1C1 = "TOTAL"
  Range("G131").Select
  ActiveCell.FormulaR1C1 = "=RC[-2]-RC[-1]"
  Range("F131").Select
  ActiveCell.FormulaR1C1 = "=SUM(R[-1]C)"
  Range("E131").Select
  ActiveCell.FormulaR1C1 = "=SUM(R[-1]C)"
  Range("F128").Select
  </code></pre>
  
  <p>So instead of having the D131 range, is there a way to have that value be specific to the cell that is active? and then moving forward to the next cells and formulas accordingly. If I'm not being clear let me know and I will try to explain myself in a different way.</p>