Hey guys,
I have a listbox that uses a dynamic named range in the ListFillRange property.
Dynamic Named Range Function:
[VBA]=OFFSET('Drop Downs'!$Q$6,0,0,COUNTA('Drop Downs'!$Q:$Q),1)[/VBA]
The range is never more than 20 values yet if the list of values is greater than the height of the listbox, it occasionally only displays 10-12 values.
Is anyone aware of a similar issue or solution?
Thanks again
F