title: Simple vbscript - values not returned from spreadsheet
body: <pre><code>If ActiveSheet.Cells(myRow, 3).Value = "" Then
      APCtext = "" &amp; APC = 2
  ElseIf ActiveSheet.Cells(myRow, 3).Value = "?" Then
      APCtext = "Unknown" &amp; APC = 3
  Else
      APCtext = ActiveSheet.Cells(myRow, 3).Value &amp; APC = 1
  End If
  </code></pre>
  
  <p>The first value this should get is not blank or a question mark, however it doesn't return this value in the else section. Can anyone point out What is wrong with this code?</p>