title: Excel VBA: Named range + string value as validation list?
body: <p>Alright, basically what I want to do is set a data validation list for a specific cell.
  This list should contain a certain range of cells I've specified PLUS a string value added to it.
  I have a dialog box that asks the user for a name, and then I need the list to display containing a set range of cells with "Other: " &amp; Name added to it.</p>
  
  <pre><code>name = "Test"
  With Worksheets("Tijdsregistratie").Cells(aangepasteRij, 4).Validation
      .Delete
      .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
      xlBetween, Formula1:="=nameRange, name"
      .IgnoreBlank = True
      .InCellDropdown = True
      .InputTitle = ""
      .ErrorTitle = ""
      .InputMessage = ""
      .ErrorMessage = ""
      .ShowInput = True
      .ShowError = True
  End With
  </code></pre>
  
  <p>Something like the above code (obviously the formula doesn't work).
  Is there any way to do this using a specific formula, or am I going to have to find another way to get this done?</p>