Hello.
Try :
Sub ConditionalPrint()
Sheets("Offering").PrintOut
If ['General Check Continuation'!I136] > 0 Then
Sheets("General Check Continuation").PrintOut
End If
End Sub
Regards.
Daniel
-----Message d'origine-----
De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De
la part de MT
Envoyé : samedi 30 octobre 2010 08:37
À : MS EXCEL AND VBA MACROS
Objet : $$Excel-Macros$$ Novice Needs Help with Basic Excel Print Macro/VBA
for Church Project
Hello. I have (2) worksheets in my Excel Workbook; "Offering" and "General
Check Continuation". Could someone please help me with the code to be able
to print the work sheet "Offering" and also worksheet "General Check
Continuation" only if cell I36 on "General Check Continuation" is greater
than 0 otherwise I need it to just print the worksheet "Offering". Thank you
Much!
--
----------------------------------------------------------------------------
------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip 2. Join our LinkedIN group @
http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and
Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
