Article View: comp.apps.spreadsheets
Article #280Re: Quattro Macros--Help!
From: Robert McDonald
Date: Fri, 20 Nov 1992 16:51
Date: Fri, 20 Nov 1992 16:51
35 lines
1774 bytes
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-mcdonaldReferences:
<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