View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jan Karel Pieterse Jan Karel Pieterse is offline
external usenet poster
 
Posts: 535
Default Application.SendKeys & Printing

Hi Vba,

Now Case 1 & 2 are great and run off as expected however Case 3 will only
print the label and halt (without error) after completing that!

Also if I add any code after the Case Select then the pages do not print
either (again without error!)


Try adding DoEvents immediately after the sendkeys command.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com