 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2007limit of named ranges
Hello do you know ? How many cells can man call under the same name in a worksheet? Can we expand the limit with vba ? How many "named range" (plage de cellules fusionnées auxquelles j'ai donné un nom) can we put in a worksheet? thanks http://www.scalpa.info Homework?  SignatureDon Guillett SalesAid Software dguillett1@austin.rr.com > > Hello [quoted text clipped - 6 lines] > > http://www.scalpa.info > Don Guillett said : Homework? not really but almost... http://www.scalpa.info ;0} > -- #1. There's a limit of how many characters you can use in the Insert|Name|Define dialog (I think 256, but not sure). And you can select the cells in the worksheet (click on the first and ctrl-click on subsequent), then use VBA to name that selection: Selection.name = "MyRange" #2. Lots and lots. I think the most I used was about 1000 in the workbook. If you're having trouble, you may want to share how many you're using. > Hello > do you know ? [quoted text clipped - 5 lines] > > http://www.scalpa.info SignatureDave Peterson hello Dave said : > And you can select the cells in the worksheet (click on the first and > ctrl-click > on subsequent), then use VBA to name that selection: > > Selection.name = "MyRange" that's what I did, but after several CTRL clic excel doesn't accept anymore clic !!! So I have to create four "named ranges" instead of one ! It's not cool ! How many is several. I did a few and then did this in the immediate window: selection.name = "Test" ?activesheet.range("Test").cells.count 101 (I clicked on 101 cells) You could also use a 5th name that combines the four. In code: union(range("test1"),range("test2"), ....).name = "AllTest" Via the insert|Name|dialog Names in workbook: AllTest Refers to: =test1,test2,test3,test4 But I'd try selecting once again. > hello > Dave said : [quoted text clipped - 8 lines] > > So I have to create four "named ranges" instead of one ! It's not cool ! SignatureDave Peterson Dave Is OP running into the 255 character limit in the "refers to:" dialog? Gord >How many is several. > [quoted text clipped - 31 lines] >> >> So I have to create four "named ranges" instead of one ! It's not cool ! I don't think so. It looks like he was trying to use selection.name in the VBE and that didn't work. But maybe I misinterpreted. > Dave > [quoted text clipped - 37 lines] > >> > >> So I have to create four "named ranges" instead of one ! It's not cool ! SignatureDave Peterson Or I'm not paying attention to beginning of thread. Better chance of that<g> Gord >But maybe I misinterpreted. I'm afraid to ask about that other invoice thread...but the curiosity is killing me. Did you get the email and did you get it to work? (shuddering in anticipation) > Or I'm not paying attention to beginning of thread. > [quoted text clipped - 3 lines] > > >But maybe I misinterpreted. SignatureDave Peterson Still having problems. The copy Karen sent me is not recognized by the Tempate Wizard so is useless. I sent her a good copy which she can customize if it works for her. The template is accessed by many on a network so some mods will need to be made. Awaiting her next report by email. Gord >I'm afraid to ask about that other invoice thread...but the curiosity is killing >me. [quoted text clipped - 10 lines] >> >> >But maybe I misinterpreted. Thanks for the update. (And to the OP: Sorry about hijacking your thread.) > Still having problems. > [quoted text clipped - 22 lines] > >> > >> >But maybe I misinterpreted. SignatureDave Peterson |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.