Quattro Macros--Help!

Article View: comp.apps.spreadsheets

Article #278

Back to comp.apps.spreadsheets Previous Next

#278

From: Stephen Sorensen
Date: Fri, 20 Nov 1992 02:10

27 lines
1515 bytes

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

############################################################################
       Steve Sorensen                     The H.John Heinz School  
                                        Carnegie-Mellon University      
             ss9o@andrew.cmu.edu                  Pittsburgh, PA 


  The stupid economy !
#############################################################################

Technical Details

Message-ID: <0f34YZW00WBN88i1sO@andrew.cmu.edu>

Path:

arc1-ca.pugleaf.net!sparky!uunet!zaphod.mps.ohio-state.edu!cis.ohio-state.edu!news.sei.cmu.edu!fs7.ece.cmu.edu!crabapple.srv.cs.cmu.edu!andrew.cmu.edu!ss9o+

Show Full Headers

Complete Article Headers

Organization: Masters student, Urban and Public Affairs, Carnegie Mellon, Pittsburgh, PA
Path: arc1-ca.pugleaf.net!sparky!uunet!zaphod.mps.ohio-state.edu!cis.ohio-state.edu!news.sei.cmu.edu!fs7.ece.cmu.edu!crabapple.srv.cs.cmu.edu!andrew.cmu.edu!ss9o+
Newsgroups: comp.apps.spreadsheets
Message-ID: <0f34YZW00WBN88i1sO@andrew.cmu.edu>
Date: Thu, 19 Nov 1992 21:10:45 -0500 
From: Stephen Sorensen <ss9o+@andrew.cmu.edu>
Subject: Quattro Macros--Help!
Lines: 27