title: Loop Through each Cells in another workbook with a For Each Loop
body: <p>quick question about the For Each In expression:<br>
  I use this line for all the rows in the same file, but different sheet: </p>
  
  <pre><code>For Each c In tarRng
          count = count + 1
          Debug.Print "c.Value: "; c.Value
          Debug.Print "cAdd: "; c.Address
          Debug.Print "count"; count
  Next 
  </code></pre>
  
  <p>tarRng is defined as all rows of the B column which works perfect, it cycles through all rows and outputs the value in the row and the address of each value in the debug screen. The count is there for a later function which I just left out here.  </p>
  
  <p>Now the question: I would like to get the B column of a different Workbook in the same folder, but when I define it like this (here fixed range since I just wanted to test it).  </p>
  
  <pre><code>For Each c In Workbooks("Nvm_Configuration_ASW.xlsm").Worksheets("Tabelle2").Range("B3:B271")   
  </code></pre>
  
  <p>It just shows the count once with the value 1 and doesn't even output c.Value or c.Address. I am sure the expression for the file and sheet are right since I tried it with the same file I am in as the filename and it worked.</p>
  
  <p>Thanks,
  Mathias</p>