title: Convert string to long in excel macro
body: <p>How can I convert string to long in excel macro. CLng is giving me type mismatch error</p>
  
  <pre><code>Dim wStr As String
  Dim w As Long
  
  wStr = "=RAND() * 0.3 + 0.35"
  w = CLng(wStr)
  </code></pre>