Using IF in a macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
If Range("N1").Value = "Yes" Then

Range("A1:N20").PrintOut

End If
 
With Activesheet
If .Range("A1").Value = 1 Then
.Prin tout
End If
End WIth
 
You must log in or register to reply here.

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

Similar Threads

Run Macro If Cell have "x" value 0
Macro to create report 1
need a macro to set the print range only for visible rows 1
Help with my macro 8
printing issue/macro needed 2
Macro to Print Active Pages in the Worksheet 10
Intuitive Macro that changes based on cell value 13
Make Macro Work On A Different PC 5

Back
Top