title: Activating a Specific Cell in Excel Using VBA Results to Error 400
body: <p>I'm just getting all the text with red font-color on a first sheet and then stored it in an array. I then want to navigate to another sheet and activate a specific cell where I want to initially put the values inside my previous array. But the part where I activate a cell on the other sheet resulted to Error 400. I'm confident enough that it's right since I already used it before. I don't know if I have some manipulation at the first part of my code that affects that.</p>
  
  <pre><code>Sub isFontRed()
      Cells(2, 1).Select
  
      Dim missingJobs(0 To 600) As String
      Dim size As Integer, row As Integer, col As Integer, jobIndex As Integer
      jobIndex = 0
  
      For row = 2 To 10 '600
          For col = 1 To 2
              If (CStr(Cells(row, col).Font.ColorIndex) = 3) Then
                 missingJobs(jobIndex) = Cells(row, col)
                 jobIndex = jobIndex + 1
             End If
         Next col
      Next row
  
      Dim jobs As String
      jobs = ""
      For i = 0 To UBound(missingJobs) - 1
          jobs = jobs + missingJobs(i) + ", "
      Next i
  
      Worksheets("New Jobs in New Folder").Activate
      Cells(4, 2).Activate
  End Sub
  </code></pre>