print only certain sheets

[Louis]

I want to print only the sheets that return a "Payment
Required" in cell L12.

Is there a way to do this?

Thanks

Louis

 

[Frank Kabel]

Hi Louis
try the following

sub conditional_print()
dim wks as worksheet
for each wks in activeworkbook.worksheets
if wks.range("L12").value = "Payment Required" then
wks.printout
end if
next
end sub

 

[Louis]

-----Original Message-----
Hi Louis
try the following

sub conditional_print()
dim wks as worksheet
for each wks in activeworkbook.worksheets
if wks.range("L12").value = "Payment Required" then
wks.printout
end if
next
end sub


--
Regards
Frank Kabel
Frankfurt, Germany

.
I'm sorry....I'm not familiar w/ using macros.

Louis

 

[Frank Kabel]

Hi
for getting started with macros have a look at
http://www.mvps.org/dmcritchie/excel/formula.htm

 

[Ron de Bruin]

Frank means this link I think
http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[Frank Kabel]

Hi Ron
$%§$ copy+paste
Thanks for the correction

 

[Ron de Bruin]

Hi Frank

Glad that I am not the only one that make mistakes <g>

Have a nice day

 

[Frank Kabel]

Hi Frank

Glad that I am not the only one that make mistakes <g>

Have a nice day

Ron
same to you
Frank