title: VBA Finding the next column based on an input value
body: <p>In a program that I'm trying to write now I take two columns of numbers and perform calculations on them.  I don't know where these two columns are located until the user tells me (they input the column value in a cell in the workbook that my code is located in).</p>
  
  <p>For example, if the user inputted "A" and "B" as the columns where all the information is in I can perform calculations based on those values.  Likewise if they wanted to analyze another worksheet (or workbook) and the columns are in "F" and "G" they could input those.  The problem is that I'm asking the user to input those two columns as well as four others (the last four are the result columns).  I did this in hopes that I would be able to make this flexible, but now inflexibility is acceptable.</p>
  
  <p>My question is, if I'm given a value of where some information will be (let's say "F") how can I figure out what the column will be after or before that inputted value.  So if I'm only given "F" I'll be able to create a variable to hold the "G" column.</p>
  
  <p>Below are examples of how the variables worked before I needed to do this new problem:</p>
  
  <pre><code>Dim first_Column As String
  Dim second_Column As String
  Dim third_Column As String
  
  first_Column = Range("B2").Text
  second_Column = Range("B3").Text
  third_Column = Range("B4").Text
  </code></pre>
  
  <p>Here the cells B2 - B4 are where the user inputs the values.  Generally I want to be able to not have the B3 and B4 anymore.  I feel like the Offset(0,1) might be able to help somehow but so far I've been unable to implement it correctly.</p>
  
  <p>Thank you,</p>
  
  <p>Jesse Smothermon</p>