try it this way:

="list!" & ADDRESS(1,$B$4) & ":" & ADDRESS(5,$B$4)


"sot" wrote:

I used the followng to allow me to access a range of lists from one combo box
based on the selection of a radio button .
=ADDRESS(1,$B$4)&":"&ADDRESS(5,$B$4) The input range is set to a name
myrange which is an =indirect($L$1) formula. This worked fine but I wanted to
place my lists in another sheet called lists, so I thought
=ADDRESS(1,$B$4,,,"list")&":"&ADDRESS(5,$B$4,,,"li st") would do it. It
appears to give the correct sheet and cell ranges as the result, but my list
box remains empty. Can I not do this or have I made a mistake somewhere?