title: Create a Excel Macro to copy formulas down across variable/unknown number of columns?
body: <p>I would like to create a single macro in excel that I can reuse on other sheets to 
  copy the formulas down from from B4:B? down to Row number X.</p>
  
  <p>I will be pasting various rows of data into Column A of several different worksheets. I will have a button on each sheet that I'd like to label "Copy Formulas". I have written formulas to parse out the text into anywhere from 3 to 250 columns, depending on the sheet. I would like the macro to highlight from B4 to Selection.End(xlToRight) then copy that selection down until the last row of data in column A. </p>
  
  <p>I was thinking of something like this but I keep getting an error on line 6. </p>
  
  <pre><code>    Dim strCurrentSheet As String
      Dim LastRow As Integer
      Dim LastCol As Integer
      LastRow = Range("A4").End(xlDown).Row
      LastCol = Range("B4").End(xlToRight).Column
      Range(Cells(4, 2), Cells(4, LastCol)).AutoFill _ 
      Destination:=Range(Cells(5, 2), Cells(LastRow, LastColumn))
  </code></pre>