title: VBA code. How to loop through a column, find values in between 0.9 and 1 and then offset 4 rows to the left of them for those values?
body: <pre><code>Set ColumnE = Worksheets("Phonebook").Range("E:E")
  Dim Names As Long
  'In this we will write the names of the people who have upcoming birthdays.
  For Each rng In ColumnE
      If (rng.Value &gt;= 0.9 And rng.Value &lt;= 1) Then
  
      End If
  Next
  MsgBox " " &amp; Names &amp; " has an upcoming birthday."
  </code></pre>
  
  <p>Now, I need your help to finish this because I have no idea what I'm doing anymore.</p>
  
  <p>Basically, what I have is a column in excel that calculates the time until a persons birthday based on their birthday; in percentages. Basically it says John was born yadda yadda, 90% until his birthday.</p>
  
  <p>I find the values in between 0.9 and 1, which is between 90% and 100% and now comes the tricky part.</p>
  
  <p>I need your help on how to find the names for those people who have their birthday coming up soon. The names are 4 rows to the left of the percentage, or 5 if you include the column with the percentages.</p>
  
  <p><strong>I want this loop to find everyone whose birthday is coming up, and enter their names into the msgbox so when I click the button, it tells me which people are having their birthday soon.</strong></p>
  
  <p>As far as I know, I'm supposed to use the .Offset thingy somehow, but I have no idea how to do that and then enter multiple names into the msgbox as one dim. </p>
  
  <p>I would really appreciate your help my dudes!</p>