listfillrange autofilter

  1. D

    ListBox ListFillRange

    I have a listbox on my worksheet. I want the listbox to reference the data on the worksheet. I have data in columns A, B, C, D & E. But, I only want to fill the listbox with the data from columns A, C, D & E (bypass 'B'). Is there a way to fill by using: Listbox1.listfillrange =...
  2. R

    ListFillRange Confusion

    I'm executing code to do an autofilter on a large block of data (Columns A to AI) several times to generate unique Fill Ranges for four ListBoxes. For some reason the second, third and fourth ListBoxes do the following: 1. Include the Copied header used for the autofilter in the ListBox (the...

Some videos you may like

This Week's Hot Topics