title: Copying data and conditional formatting from one workbook to another using VBA
body: <p>I am trying to copy data and conditional formatting from one workbook to another. I can get the data to transfer over to my primary workbook, but the conditional formatting is being removed. How do I copy the data and conditional formatting from one workbook to another?</p>
  
  <p>This is what I have so far:</p>
  
  <pre><code>Dim Master As Workbook 
  Set Master = ActiveWorkbook 
  Dim lastRow As Long 
  lastRow = ActiveSheet.Cells(Rows.Count, 2).End(xlUp).Row 
  Range("A2:AE2" &amp; lastRow).Select Selection.Copy 
  Master.Activate
  ThisWorkbook.ActiveSheet.Cells(lastRow, 1).Paste
  </code></pre>
  
  <p>I have tried Paste Special and it does not work either.</p>