Path: utzoo!utgpu!jarvis.csri.toronto.edu!rutgers!iuvax!cica!tut.cis.ohio-state.edu!pt.cs.cmu.edu!andrew.cmu.edu!bo09+ From: bo09+@andrew.cmu.edu (Brock Eugene Organ) Newsgroups: comp.sys.ibm.pc Subject: Lotus Macro question Message-ID: Date: 6 Jul 89 20:39:21 GMT Organization: Class of '92, Carnegie Mellon, Pittsburgh, PA Lines: 27 Would anyone who frequently uses the 'macro' language supplied with 1-2-3 be able to answer my question about it: Is there a way to reference (or point to) a range name with another range name within a macro? Example: '\v '{getlabel "name:", namebuf} '/ rnc @@(namebuf) '~.{right}{down 2}~ {put @@(namebuf),1,1,"This is the new range"} <-- here is the error The macro (\v) here asks the user for the name of a new range, and creates a new range (the name of the range is whatever label the user entered). The put statement is supposed to place a label inside of this new range, but macro execution stops and gives an error in the put statement. It specifically will not accept the @@(range) function as a valid range. I would hope to use this macro to dynamically create ranges; but if there is no way to reference the newly created range then any macros that use ranges are limited to one explicit range for which it applies. Is there any way to use some type of function to represent any old generic range? Thank you for your time, Brock Organ (bo09@+andrew.cmu.edu)