| 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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I set up a Dynamic Named Ranges in Excel 2007
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I set up a Dynamic Named Ranges in Excel 2007
Best thing to do is to get Jan Karel Pieterse's NameManager utility,
http://www.jkp-ads.com/OfficeMarketPlaceNM-EN.asp. You will see those names in this utility, and it is a far better way to manage names anyway. -- __________________________________ 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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I set up a Dynamic Named Ranges in Excel 2007
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I set up a Dynamic Named Ranges in Excel 2007
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. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I set up a Dynamic Named Ranges in Excel 2007
Convert your named range(s) into an Excel 2003 List or Excel 2007 Table. The names of the columns will become dynamic and appear in the Name Box. Also check 2007 Options Proofing AutoCorrect options |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I set up a Dynamic Named Ranges in Excel 2007
I don't seem able to get the Dynamic Named Range in my post to work in VBA.
Name SpendRate =OFFSET(Spend Rates!$L$5,0,0,COUNTA(Spend Rates!$M:M),1) I'm trying to copy column L from row 5 down to last row of data. Range("SpendRates").Copy Macro stops at this line. TIA -- Thank you Aussie Bob C Little cost to carry knowledge with you. Win XP P3 Office 2007 on Mini Mac using VMware. |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I set up a Dynamic Named Ranges in Excel 2007
=OFFSET('Spend Rates'!$L$5,0,0,COUNTA('Spend Rates'!$M:M),1)
-- __________________________________ HTH Bob "Aussie Bob C" wrote in message ... I don't seem able to get the Dynamic Named Range in my post to work in VBA. Name SpendRate =OFFSET(Spend Rates!$L$5,0,0,COUNTA(Spend Rates!$M:M),1) I'm trying to copy column L from row 5 down to last row of data. Range("SpendRates").Copy Macro stops at this line. TIA -- Thank you Aussie Bob C Little cost to carry knowledge with you. Win XP P3 Office 2007 on Mini Mac using VMware. |
| Reply |
| 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) | |||
Linear Mode
