View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default Autofilter of List box Rowsource

I suspect you didn't select the entire range when you autofiltered it. Try
that and see if it helps.

"Yomi" wrote:

I asked this in one of my earlier post but I have not got solution. Can
anyone help please?.
When I filter my rowsource of a list box which is a range. Rows that do not
meet the criteria are not hidden in the listbox display contrary to the
worksheet view. In other words, all rows are displayed in the list box which
I dont want. How can I make my list box display only the unhidden rows

Thank in advance