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.