title: New to VBA. More than one input to run the sub
body: <p>I have a sub which require me to input one serial number at a time to run the program. However, I want to select a range of cells in excel, for example, &quot;A1:A15&quot; as my inputs. So that I don't have to run the program by entering the serial number one by one, which is time-consuming. Is there any way to do that?</p>
  <p>The sub2 requires the input of serial number as string.</p>