🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.apps.spreadsheets
Article #280

Re: Quattro Macros--Help!

#280
From: Robert McDonald
Date: Fri, 20 Nov 1992 16:51
35 lines
1774 bytes
In article <0f34YZW00WBN88i1sO@andrew.cmu.edu> Stephen Sorensen <ss9o+@andrew.cmu.edu> writes:
>Date: Thu, 19 Nov 1992 21:10:45 -0500 
>From: Stephen Sorensen <ss9o+@andrew.cmu.edu>
>Subject: Quattro Macros--Help!
>Hi folks,
>Can ANYONE answer my question about using macros in Quattropro (I'm
>using qp 4.0 for windows) ? All I want to do is have a macro go through
>and color all the cells with numbers; I want it to leave the blank cells
>alone. So far, I've got something like this:
>                    {IF #NOT#@Active_Cell}{RIGHT}
>                    {Setproperty....}
>                    {Right}
>
>I keep getting an error message about an invalid statement. Does anyone
>know how to properly use such an "IF" clause ? The Quattro manuals seem
>basically useless.
>
>Any help would be GREATLY appreciated.
>
>Thanks,
>Steve
>

There is one easy solution without a macro, and I can at least give you a 
start on a macro that will do what you want.

The non-macro solution is to go to /options,colro


***********************************************
Robert McDonald  / Internet: r-mcdonald@nwu.edu 
Fin. Dept., Kellogg School, Northwestern Univ.  
2001 Sheridan Rd., Evanston, IL 60208-2006   
voice: 708-491-8344 / Fax 708-491-5719    
***********************************************
Technical Details
Message-ID: <r-mcdonald.13.0@nwu.edu>
Path: arc1-ca.pugleaf.net!sparky!uunet!think.com!rpi!zaphod.mps.ohio-state.edu!news.acns.nwu.edu!nwu.edu!r-mcdonald
References: <0f34YZW00WBN88i1sO@andrew.cmu.edu>

Show Full Headers
Complete Article Headers
Newsgroups: comp.apps.spreadsheets
Path: arc1-ca.pugleaf.net!sparky!uunet!think.com!rpi!zaphod.mps.ohio-state.edu!news.acns.nwu.edu!nwu.edu!r-mcdonald
From: r-mcdonald@nwu.edu (Robert McDonald)
Subject: Re: Quattro Macros--Help!
Message-ID: <r-mcdonald.13.0@nwu.edu>
Lines: 35
Sender: usenet@news.acns.nwu.edu (Usenet on news.acns)
Organization: Northwestern University
References: <0f34YZW00WBN88i1sO@andrew.cmu.edu>
Date: Fri, 20 Nov 1992 16:51:45 GMT