I have the following in row source property :
=OFFSET(HLT51607!$a$2,0,0,COUNTA(HLT51607!$a:$a)-1,1)

this range is also called student_id_no

My problem is that I would like to also display Student name. this is not
happening

I have selected 2 for columncount but it still only lists one. The second
column range name is called student_name.

Firstly how do I fix my problem
also is there a better way to enter the rowsource details... perhaps by
using the named range instead of $a3$?

Put this as the ColumnWidth Property: 25 pt;20 pt, (Column1;Column2). You
will have to adjust it to your application.
--
Cheers,
Ryan


"Paul" wrote:

I have the following in row source property :
=OFFSET(HLT51607!$a$2,0,0,COUNTA(HLT51607!$a:$a)-1,1)

this range is also called student_id_no

My problem is that I would like to also display Student name. this is not
happening

I have selected 2 for columncount but it still only lists one. The second
column range name is called student_name.

Firstly how do I fix my problem
also is there a better way to enter the rowsource details... perhaps by
using the named range instead of $a3$?

Sorry Ryan tried this and it still does not work


"RyanH" wrote:

Put this as the ColumnWidth Property: 25 pt;20 pt, (Column1;Column2). You
will have to adjust it to your application.
--
Cheers,
Ryan


"Paul" wrote:

I have the following in row source property :
=OFFSET(HLT51607!$a$2,0,0,COUNTA(HLT51607!$a:$a)-1,1)

this range is also called student_id_no

My problem is that I would like to also display Student name. this is not
happening

I have selected 2 for columncount but it still only lists one. The second
column range name is called student_name.

Firstly how do I fix my problem
also is there a better way to enter the rowsource details... perhaps by
using the named range instead of $a3$?