D dusty Registered User. Local time Yesterday, 20:34 Joined Aug 20, 2009 Messages 42 Dec 2, 2009 #1 Hi quick question is there functionality for naming ranges in this plugin? In normal excel I can select cells and name the range, then if extra rows are added the range expands with the rows. Cheers Dusty
Hi quick question is there functionality for naming ranges in this plugin? In normal excel I can select cells and name the range, then if extra rows are added the range expands with the rows. Cheers Dusty
Trevor G Registered User. Local time Today, 04:34 Joined Oct 1, 2009 Messages 2,361 Mar 26, 2010 #2 Have you set the references to Excel in the VBA screen if so you should be able to name ranges as you would for excel. So you would have to name the object on the form first then use the name before adding a name to the range on this control.
Have you set the references to Excel in the VBA screen if so you should be able to name ranges as you would for excel. So you would have to name the object on the form first then use the name before adding a name to the range on this control.