title: Method 'Range' of object '_Global' failed Error
body: <pre><code>1.Dim destbook As Workbook
  2.Dim destsheet As Worksheet
  3.Set destbook = ActiveWorkbook
  4.Set destsheet = destbook.Sheets(1)
  5.Dim ct As Integer
  6.destsheet.Range(&quot;C1048576&quot;).Select
  7.ct = Selection.End(xlUp).Row
  8.Windows(&quot;Book1.xlsm&quot;).Activate
  9.Sheets(&quot;Sheet1&quot;).Activate
  10.Range(Cells(ct, 1)).Offset(1, 0).Select
  </code></pre>
  <p>Here on 10th line i am getting a error saying &quot;Method 'Range' of object '_Global' failed&quot;.</p>