macro within a macro

Giganews Newsgroups
Subject: macro within a macro
Posted by:  Jim Bohnet (james.bohn…
Date: Fri, 10 Oct 2003

I want to have a macro which looks at the results in a
particular cell.  If the cell says "yes", then the macro
should select a specific named range in the worksheet and
print it.  But if the answer is "no" or the cell is blank,
then a different named range should be selected and
printed.  I tried setting up two print macros - 1 for each
range.  I then wanted to have a macro button that executed
an if statement to select which range to print, but
couldn't make this operable.  Does anyone have a way to
accomplish this selected area printing- either with or
without macros??