title: Excel macro - unable to call cell value
body: <p>In my worksheet some cells values are based on other cells</p>
  
  <pre><code>Info worksheet
  A1: 5
  B1: =A1
  Design worksheet
  A1:
  </code></pre>
  
  <p>Is there a way to copy and read the value in B1? I'm trying to use the value in a for loop, with no luck.</p>
  
  <pre><code>Sheets("Info").Select
  For i = 1 to 5
      If Range("B" &amp; i).Value &lt;&gt; 0 Then
          Range("B" &amp; i).Copy Destination:=Sheets("Design").Range("A" &amp; x)
          'Sheets("Design").Range("A" &amp; x).Value = Sheets("Offerte").Range("B" &amp; i).Value
          x = x + 1
      End If
  Next i
  </code></pre>