Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel will not include all of my non-adj ranges in a named range??
Does anyone know why excel 2002 will not include all of my non-adjacent
ranges in a named range? It includes 10 of my ranges and then just refuses to include the last two ranges I highlight. Any ideas for a workaround are welcome. Thanks in advance. |
#2
|
|||
|
|||
How are you creating it?
If you're using the namebox and already used that name, excel thinks you want to select that existing range. Just Insert|name|define and define the name there-- or delete the name and then use the namebox. Renlimanit wrote: Does anyone know why excel 2002 will not include all of my non-adjacent ranges in a named range? It includes 10 of my ranges and then just refuses to include the last two ranges I highlight. Any ideas for a workaround are welcome. Thanks in advance. -- Dave Peterson |
#3
|
|||
|
|||
I did it the way you described and the name was not repeated. Any other
suggestions? Thanks again for your help. "Dave Peterson" wrote: How are you creating it? If you're using the namebox and already used that name, excel thinks you want to select that existing range. Just Insert|name|define and define the name there-- or delete the name and then use the namebox. Renlimanit wrote: Does anyone know why excel 2002 will not include all of my non-adjacent ranges in a named range? It includes 10 of my ranges and then just refuses to include the last two ranges I highlight. Any ideas for a workaround are welcome. Thanks in advance. -- Dave Peterson |
#4
|
|||
|
|||
There is a limit on how long the string would be in the insert|name dialog.
Maybe you're approaching this length. But I don't recall having any problem using the name box (if that name hasn't been used before). Or you could try this: Select your ranges hit alt-f8 (to get to the VBE hit ctrl-g (to get to the immediate window) type this and hit enter selection.name = "myNameHere" then back to excel to see if that worked. Renlimanit wrote: I did it the way you described and the name was not repeated. Any other suggestions? Thanks again for your help. "Dave Peterson" wrote: How are you creating it? If you're using the namebox and already used that name, excel thinks you want to select that existing range. Just Insert|name|define and define the name there-- or delete the name and then use the namebox. Renlimanit wrote: Does anyone know why excel 2002 will not include all of my non-adjacent ranges in a named range? It includes 10 of my ranges and then just refuses to include the last two ranges I highlight. Any ideas for a workaround are welcome. Thanks in advance. -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do I set up a macro to excel that include the e-mail address | Excel Discussion (Misc queries) | |||
Urgent Help Required on Excel Macro Problem | Excel Discussion (Misc queries) | |||
Installing: Microsoft Excel Feature | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) |