Using IF in a macro
 

I have a macro that prints out several pages at the end of the work week, I
now need to know if there is a way to print a page with the weekly paperwork
only if it has a value in a specific field. Any ideas?

Using IF in a macro
 

If Range("N1").Value = "Yes" Then

Range("A1:N20").PrintOut

End If

"justaguyfromky" wrote in message
...
I have a macro that prints out several pages at the end of the work week,
I
now need to know if there is a way to print a page with the weekly
paperwork
only if it has a value in a specific field. Any ideas?

Using IF in a macro
 

With Activesheet
If .Range("A1").Value = 1 Then
.Prin tout
End If
End WIth

--

HTH

RP

"justaguyfromky" wrote in message
...
I have a macro that prints out several pages at the end of the work week,
I
now need to know if there is a way to print a page with the weekly
paperwork
only if it has a value in a specific field. Any ideas?