Karen,

If by this:

I've referenced that name in a dropdown box; however, only the very first
value appears when the list is dropped down.

you mean that you are using Data Validation, then the list needs to reference the name using

=Name

When I do that, everything works well for me.

HTH,
Bernie
MS Excel MVP


"KarenB" wrote in message
...
I have defined a NAME with the following formula:
=OFFSET(CORPORATE!$A$1,0,0,1,COUNTA(CORPORATE!$1:$ 1))
which I think should return all values in row 1 of the "Corporate" sheet.

I've referenced that name in a dropdown box; however, only the very first
value appears when the list is dropped down.

When I click on the formula in the Define Name dialog box, all values in
that row are highlighted.

What am I missing?