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$?
> >