Thread
:
simple print loop crashes
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
simple print loop crashes
printOUT will not stop. printPREVIEW will until you touch the c key or
print. That's what preview means......
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Ken" wrote in message
...
I can't figure out why the following code stops executing after each
loop. When I step through the code it works fine. When I run it it
stops execution is interupted after each loop; if I "continue" it
picks up and works fine. Is there something that needs to follow the
PrintPreview (or PrintOut) statement to keep it from interupting?
Sub test2()
For i = 1 To 3
Worksheets(i).PrintPreview
Next i
End Sub
Thanks
Ken
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett