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