| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
address function
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
address function
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
address function
Perfect! Thanks very much!
"Vergel Adriano" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help With Address Function | Excel Worksheet Functions | |||
| address function | Excel Worksheet Functions | |||
| address() function | Excel Worksheet Functions | |||
| ADDRESS Function | Excel Worksheet Functions | |||
| Use address function or other | Excel Worksheet Functions | |||
Linear Mode
