FORMULA TO PRINT

[Dani]

Can anyone here help me with a macro or formula that would print all the
worksheets in a book that contained a value greater than 0 in one cell (H17).

Also, is there a good reference for all the commands you can use in formulas
and macros? Maybe a website?

 

[Frank Kabel]

Hi
see:
http://www.rondebruin.nl/print.htm#Hide

 

[Guest]

"Also, is there a good reference for all the commands you
can use in formulas
and macros? Maybe a website?"

I've learned quite a bit about formulas just by using Help
(F1).

Gene

 

[Dani]

Thanks, Frank. I'll see what I can do with that webpage. I did try Help for
this first, but by typing in various versions of "print", "formula" and
"macro", it directed me to this forum. I think I'm just not very good at
searching the help screens for what I want to do.

 

[Ron de Bruin]

Hi Dani

Use this macro

Sub test()
Dim sh As Worksheet
For Each sh In ThisWorkbook.Worksheets
If sh.Range("H17").Value > 0 Then sh.PrintOut
Next
End Sub

http://www.mvps.org/dmcritchie/excel/getstarted.htm
See David McRitchie's site if you just started with VBA