Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!usc!orion.oac.uci.edu!ucivax!ddoherty From: ddoherty@ics.uci.edu (Donald Doherty) Newsgroups: comp.windows.ms Subject: Excel 3.0 Macros - NEW() Function Keywords: EXCEL MACROS Message-ID: <27D016A1.18908@ics.uci.edu> Date: 2 Mar 91 21:18:25 GMT Sender: ddoherty@ics.uci.edu (Donald Doherty) Organization: UC Irvine Department of ICS Lines: 21 The NEW() function works as advertised when I put NEW(2,2) into a macro. A chart is created with the first row or column of numbers in the worksheet used as x axis labels. HOWEVER! When I use the NEW() function like this: NEW("template",2) the dialog box invariably pops up to ask for specification of data arrangement (which should be taken care of by the 2 after the comma as in the first example). Has anyone had the same problem? Any suggestions on how to solve it? Thank you! Don D. ddoherty@ICS.uci.edu