Thread: Dropdown List from values in a Cell Range
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
moon[_5_] moon[_5_] is offline
external usenet poster
  
Posts: 40
Default Dropdown List from values in a Cell Range

For Each YourCell in YourRange
If ActiveCell.Value < Empty Then
YourCombo.AddItem ActiveCell.Value
End If
Next


"DrKacso" schreef in bericht
...
How do I get a list of only the nonblank values from a cell range?


Reply With QuoteReply With Quote