I already do it in my other sheets but I am copying only lines down so it's easy. I'm thinking of a way to have a macro copy down those 5 rows of text (which will later be formulas pulling data from another sheet) based on whether a cell has a quantity. I don't think I explained my other question earlier clearly. Maybe the macro is sending the data so quickly that the printer can't process it all and hiccups every few labels. Anyway, it doesn't affect the usefulness of the code as it works great. The funny thing is the printer is printing several labels at a time and sometimes not. I was using the name of the printer in quotes as I saw online, but do I have to name the port? Thanks for the help.Īpplication.Dialogs(xlDialogPrinterSetup).ShowĪctiveSheet.PrintOut Copies:=Range("A5").ValueĪctiveSheet.PrintOut Copies:=Range("A11").Value I was also having trouble naming the printer in the code. So I was going to repeat the code that many times but I doubt that's the best way. I may have as many as 20 or 30 ranges to print one after the other in one pass. I included my test excel file with just 2 ranges and with a cell next to each range containing the number of copies. The idea is to print several ranges of text sequentially - the range of each section will not change. I have the code working OK so far but I think it needs improvement. Hi, I am trying to print labels from an excel file to a Zebra thermal printer.
0 Comments
Leave a Reply. |