When Autofilter has been selected, and we look in the drop down box in a selection, the total number of the 'lines' in the drop down box is not much more than 1000 lines. That means i dont get the data of rows over these 1000 records. How do i increase the total nbr of lines in the dropd down box.
pls advise
pls advise