Path: utzoo!utgpu!news-server.csri.toronto.edu!mailrus!uunet!aecom!werner From: werner@aecom.yu.edu (Craig Werner) Newsgroups: comp.sys.ibm.pc Subject: Lotus macro question. Message-ID: <2874@aecom.yu.edu> Date: 12 Jun 90 03:34:02 GMT Distribution: usa Organization: Albert Einstein Coll. of Med., NY Lines: 23 If it's in the manual, it's certainly escaped me... I'd like to write a "simple" macro that prompts for six consecutive values, plugs these values into six adjacent columns, and then extends a graph set one row down. I thought I had it, but after a time I realized that older values came to resemble newer values. In other words, all the new rows were references to the old rows, and hence all the data changed together. Is there any way to combine {getnumber} with an absolute reference to the current cell, and place a value there? I assume that it's simple and I'm just missing it. Is there a good book on macro programming in Lotus (really Quattro Pro with Lotus 1-2-3 tree) as opposed to using the spreadsheet, a skill I've already mastered. -- Craig Werner (future MD/PhD, 4.5 years down, 2.5 to go) werner@aecom.YU.EDU -- Albert Einstein College of Medicine (1935-14E Eastchester Rd., Bronx NY 10461, 212-931-2517) "Morphology is part science and part 'Ipse Dixit.' "