title: Run-time error '1004' - Method 'Range' of object'_Global' failed
body: <p>I have a problem in VBA with a line throwing back an error. </p>
  
  <p>What the macro is intended to do is find a particular cell then paste data into it.</p>
  
  <p>The code is as following:</p>
  
  <pre><code>'To find Column of Customer imput
  For Each cell In Range("B4:M4")
  
          If cell.Value = strLeftMonth Then
              DataImportColumn = cell.Column
  
          End If
  
  Next
  
  
  For Each cell In Worksheets("data customer monthly 2013").Range("A3:A9999")
  
  'First Customer
  If cell.Value = strFirstCustomer Then
          DataImportRow = cell.Row
  
      Range(DataImportColumn &amp; DataImportRow).Offset(0, 2).Value = iFirstCustomerSales ****
  End If
  </code></pre>
  
  <p>After running the above code; The code crashes giving the <code>1004 run-time error</code> on the <code>asterisk'd</code> line. Also <code>DataImportColumn</code> has a value of <code>7</code> and <code>DataImportRow</code> has a value of <code>5</code>. </p>
  
  <p>Now my concern is that Columns aren't referenced as numbers but letters, so it must be that my code can never work because its a terrible reference. </p>
  
  <p>Does anyone have any suggestions how I can make the above work? </p>