Absolutely, you can use them in a formula, in VBA, and even in EditGoto
(Ctl-G) where you can type in that name and it will THEN evaluate and goto
that range.

--
__________________________________
HTH

Bob

"Aussie Bob C" wrote in message
...
Dynamic Named Ranges can still be used in functions & programing Y/N?
Just selecting one in the Names Box is not possible.
--
Thank you

Aussie Bob C
Little cost to carry knowledge with you.
Win XP P3 Office 2007 on Mini Mac using VMware.


"Bob Phillips" wrote:

Dynamic named ranges do not, and never have, appeared in the Names Box.
This
is because you can select the name in that box and Excel will select the
range. Unfortunately, Excel seems incapable of evaluating the name upon
selecting to get the actual range, so they omit it.

--
__________________________________
HTH

Bob

"Aussie Bob C" wrote in message
...
I tried "cpearson" Dynamic Ranges
=OFFSET(Spend Rates!$L$5,0,0,COUNTA(Spend Rates!$M:M),1)
to create a dynamic range in Column L starting at row 5.

It appeared in a list for editing, but didn't appear in the Name Box
drop
down list.
Have I omitted something or has the syntext changed for Excel 2007?

Tried searching for it in Windows online help, not a thing about
Dynamic
Named Ranges came up.

TIA

--
Thank you

Aussie Bob C
Little cost to carry knowledge with you.