New topic: Excel VBA Automatic Creation of Range Names from Duplicates
<http://forums.realsoftware.com/viewtopic.php?t=31366> Page 1 of 1 [ 1 post ] Previous topic | Next topic Author Message BarrySumpter Post subject: Excel VBA Automatic Creation of Range Names from DuplicatesPosted: Wed Dec 02, 2009 5:07 am Joined: Sat Apr 28, 2007 2:51 am Posts: 125 Excel VBA Automatic Creation of Range Names from Duplicates -------------------------------------------------------------------------------- Hi all, I can automatically create range names by selecting a range of 2 cells wide. Then selecting the menu Forumulas | (Name Manager) Create from Selection | Left Column | OK Works OK thru Dec. But the 2nd Jan popups a dialog asking to over write the first Jan. Can anyone assist with VBA code to do this: i.e. Create a name range from column A for the single cells from column B. Trapping duplicate name errors: And if Jan already exists - continually try Jan2 or Jan3 etc until named. -- Over 1500 classes with 29000 functions in one REALbasic plug-in collection. The Monkeybread Software Realbasic Plugin v9.3. http://www.monkeybreadsoftware.de/realbasic/plugins.shtml [email protected]
