title: Method Range of Object Global Failed when assigning named range
body: <p>I've searched for about an hour but found nothing that solves my problem. The following code </p>
  
  <pre><code>Dim q3ZFj1 As Range
  Dim q4ZFj1 As Range
  Dim q3ZFj2 As Range
  Dim q4ZFj2 As Range
  
  Dim q3Uebj1 As Range
  Dim q4Uebj1 As Range
  Dim q3Uebj2 As Range
  Dim q4Uebj2 As Range
  
  Dim cRow As Long
  Dim cCol As Long
  
  Dim startYear As Integer       
  Dim nextYear As Integer        
  
  Dim q3j1Name As Variant
  Dim q4j1Name As String
  Dim q3j2Name As String
  Dim q4j2Name As String
  
  Dim c As Variant
  
  For i = 3 + 1 To Sheets.Count
  
  Set q3ZFj1 = Worksheets(i).Range("C501:I512")
  Set q4ZFj1 = Worksheets(i).Range("C521:I532")
  Set q3ZFj2 = Worksheets(i).Range("C601:I612")
  Set q4ZFj2 = Worksheets(i).Range("C621:I632")
  
  startYear = q3ZFj1.Cells(-1, 0)
  nextYear = startYear + 1
  
  q3j1Name = "Q3_" &amp; startYear
  q4j1Name = "Q4_" &amp; startYear
  q3j2Name = "Q3_" &amp; nextYear
  q4j2Name = "Q4_" &amp; nextYear
  
  Set q3Uebj1 = Range(q3j1Name)
  Set q4Uebj1 = Range("Q4_" &amp; startYear)
  Set q3Uebj2 = Range("Q3_" &amp; nextYear)
  Set q4Uebj2 = Range("Q4_" &amp; nextYear)
  </code></pre>
  
  <p>Runs fine when stepping through with F8, but when running, I get the Error mentioned in the Title.</p>
  
  <p>It doesn't matter whether I refer to the range using <code>Range(q3j1Name)</code> or <code>Range("Q3_" &amp; startYear)</code> or if the Variable for <code>q3j1Name</code> is declared as String or Variant.</p>
  
  <p>The strings <code>q3j1Name</code>, etc. initialize fine, <code>q3j1Name</code> to <code>"Q3_2012"</code> for example. <code>Set q3Uebj1 = Range("Q3_2013")</code> works just fine. </p>
  
  <p>The named ranges exist, but in a different worksheet. <code>Set q3Uebj1 = Worksheets(2).Range(q3j1Name)</code> doesn't work either. </p>
  
  <p>Does anybody have a suggestion how I can either fix this or workaround it? </p>
  
  <p>Basically each worksheet being stepped through contains a year value, based on which a range in worksheet2 is used.</p>
  
  <p>Thanks in advance for any help...</p>