title: use inputbox as excel range
body: <p>I'd like the user to input a range of cells such as A1:Z26. I've tried adding quotations, I've tried have 2 inputboxes, one for beginning and end of the range. But it errors out everytime with: 'method range of object_global failed'</p>
  
  <p>I know it's a simple syntax issue (I think) so can anyone point me in the right direction in terms of how to have the user input a range that works in the <code>set rng = range(msg)</code></p>
  
  <pre><code>Sub iterationLoop()
  
  Dim rng As Range, iteration As Range
  
  msg = "What is the range you'd like to look at: (e.g. A1:B2)"
  InputBox (msg)
  Set rng = Range(msg)
  
  For Each iteration In rng
  iteration.Select
  If iteration = vbNullString Then
  iteration = "add value"
  MsgBox ("Cell: " &amp; Selection.Address &amp; " has no value")
  End If
  
  Next
  
  End Sub
  </code></pre>