title: This array is fixed or temporarily locked
body: <p>I am using split function and assigning the value in a variable and running the code in loop after few iterations its giving an error of "This array is fixed or temporarily locked (Visual Basic)"..</p>
  
  <p>e.g; here value of movies_cat1 read from excel is in form of this------
  "Movies->List All Movies , Movies->World Cinema->Asia , Movies->Movies by Language->Sinhalese , Movies->Drama"</p>
  
  <pre><code>For crow = 1 To 100
  
      Value = Worksheets("Movies_categories").Range("A" &amp; crow).Value
      cat_final = Worksheets("Movies_categories").Range("B" &amp; crow).Value
  
      If Value = "y" Or Value = "Y" Then
  
        'Loop for reading the data from tabsheet- Movies
  
        For crowss = 5 To 3000
          movies_cat1 = Worksheets("Movies").Range("B" &amp; crowss).Value
          movies_language = Worksheets("Movies").Range("C" &amp; crowss).Value
  
          If movies_language = "English" Then
  
            Temp = Split(movies_cat, ",")  'run time Error:10  occurs here..
  
            For Each boken_c In Temp
              flag = 0
              boken_c = Trim(boken_c)
  
              If RTrim(LTrim(boken_c)) = LTrim(RTrim(cat_final)) Then
                flag = 1
                GoTo Line4:
              End If
            Next boken_c
          End If
        Next crowss
      End If
  Line4:    Next crow
  </code></pre>
  
  <p>Error occurs at this statement: <code>Temp = Split(movies_cat, ",")</code>, it says that the array is fixed or temporarily locked, because i think initially its taking 'temp' as a variable, but while returning the value of split function, variable 'Temp' becomes array after completion of first loop(i.e after crow = 6,7....)</p>