| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set up a Dynamic Named Ranges in Excel 2007
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using named ranges in dynamic charts (excel 2007) | Excel Worksheet Functions | |||
| Named ranges in Excel 2007 | Excel Discussion (Misc queries) | |||
| Dynamic Named Ranges | Excel Discussion (Misc queries) | |||
| Dynamic Named Ranges | Charts and Charting in Excel | |||
| Dynamic Named Ranges | Excel Discussion (Misc queries) | |||
Threaded Mode
