Coding for printing (without preview)

  • Thread starter Thread starter Peter McCaul
  • Start date Start date
P

Peter McCaul

Sub printall()
For i = 1 To 6
[c1] = i
ActiveSheet.PrintPreview
Next
[c1] = 0
End Sub

This piece of coding will printout a filtered chart. My problem is that it
previews the chart and then you have to click the print button to print. I
don't want that. I would like it to print without previewing. I have run
the code without the word printpreview and it still doesn't work. Any help
is appreciated. Thanks.
 

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

Excel VBA - Problem with Closing Print Preview 0
Print with sevral different print area's 2
print preview in loop 1
print command from command button in userform causes double chart 5
Print problems w/ charts excel 2003/2007 3
Print Preview 12
BeforePrint & PrintPreview Hangs 1
Leftover formatting in code 3

Back
Top