Can you give me an example of how I would do this please?

"Bob Phillips" wrote:

Not unless you iterate through them and pick out the non-hidden items.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"enyaw" wrote in message
...
The information I want to put in the list box is within the range B63 to
G271.
Some of the information in this range I don't want shown.
If I hide these rows is there any way of not showing them in the list box?

"Bob Phillips" wrote:

You could set the RowSource property dynamically in code.

When would you want the different ranges?

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"enyaw" wrote in message
...
I am using the row source to populate a list box. Is there a way to
populate
the list box using different ranges of a worksheet. eg B63:G71 and
B82:G85.