Thank you, it finally worked this time by rewriting it to match yours and
replacing my source cell of C16. The first few times I tried it exactly as
you had it written, all I got was blank cells, so I rewrote it trying to get
it to work. The drop down box for the range name selection is really neat.
Is it easy to create?
--
Lori


"Max" wrote:

=IF($C$16="BPOH",BPOH,OFFSET(INDIRECT($C$16),ROW(A 1)-1,COLUMN(A1)-1))

The above wasn't consistent with what was suggested earlier

=IF($C$16="BPOH",BPOH, ...
should read as:

=IF($C$16="","", ...

Try this working sample file which illustrates the earlier suggestion:
http://www.savefile.com/files/387065
Display specified name range.xls

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
Lori wrote:
The calc mode is set to automatic.
formula: (cell C16 is where BPOH choice is entered)
=IF($C$16="BPOH",BPOH,OFFSET(INDIRECT($C$16),ROW(A 1)-1,COLUMN(A1)-1))

--
Lori