title: Select CASE / CASE over range of cells
body: <p>I have a spreadsheet with 36K lines. Each of the 36K lines will be matched to one of about 350 numbers. When that number is matched, I will have text and colons input into another column on the same row as the matching number. The questions I have are:</p>
  
  <ol>
  <li>How can I have the macro run over a range (Example: T2:T36000) and return a value for each row?</li>
  <li>Can I do this by column instead of the row range. (Example: Column called Category, instead of T2:T36000). The reason for this is that the number of rows in each column will be changing.</li>
  </ol>
  
  <p>This works for one row at a time, but I don't want to have to do this for each row. I realize I will have to put values for each of the 350 different numbers.</p>
  
  <pre><code>Sub CategoryChanger()
  Select Case Range("AS2").Value
    Case 1492
     Range("T2") = "IT DOES NOT WORKS"
    Case 1491
     Range("T2") = "IT WORKS"
  End Select
  End Sub
  </code></pre>
  
  <p>Thanks ahead of time.</p>