The named range "PAID" is a dynamic range.
There is no error if this named range has more than one row (where each row has a value),
which in other words, the ListBox1 is populated without error.
But if this named range has only one row (with value),
it throw me an error 381 "could not set the list property".
I've tried something like this :
And it still gives me an error, this time Error 1004 "method range of object global failed".
How do I resolve the problem ?
Any kind of respond would be greatly appreciated.
Thank you in advanced.
Bookmarks