title: Error in Excel 2010, PasteSpecial method of Range Class failed within macro
body: <p>Following is my code that's throwing this error:</p>
  
  <blockquote>
    <p>PasteSpecial method of Range class failed</p>
  </blockquote>
  
  <p>Error is throwing only when I'm trying to debug.</p>
  
  <pre><code>Range(Cells(7, 1), Cells((Rowrange + 7), 2)).Select
  Selection.PasteSpecial Paste:=xlValues
  
  
    ' my complete code
  
  strSheetName = "sheet1"
  Sheets(strSheetName).Select
  B6 = Range("B6").Value
  B7 = Range("B7").Value
  Range(Cells(11, 1), Cells((Rowrange + 11), 2)).Select
  Selection.Copy
  
  strSheetName = "sheet2"
  Sheets(strSheetName).Select
  ' Range(Cells(7, 1), Cells((Rowrange + 7), 2)).Select
  '.Range(Cells(7,1), .Cells(RowRange + 7, 2). PasteSpecial Paste := xlValues
  'Selection.PasteSpecial Paste:=xlValues
  With ActiveSheet
  .Range(.Cells(7, 1), .Cells(Rowrange + 7, 2)).PasteSpecial Paste:=xlValues
  End With
  </code></pre>
  
  <p>Is there a way to avoid this error?</p>