Conditional auto printing in excell?

G

Guest

How do I write macro for conditional auto printing in excell? I have tried
things like:
if L2>0 then print. This would be that a number greater than 0 would get the
system to print the page. This is to be encorporated into an existing macro
that currently prints every page even if no data is on line 2 of the
spreadsheet.
 
D

Don Guillett

You should always post your coding efforts for comments and suggestions.
if range("l2")>0 then range("a2:l2").printout
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top