However, this gives me an "Run time error 1004 - Application-defined or Object-defined error" (which makes sense because Cell.Value is not an object) and if I remove the.
If Range("E" & r) "" Then 'the r values correspond with row numbersĪctiveSheet.PrintOut copies:=Range("A" & r).Value, collate:=True, IgnorePrintAreas:=False It contains a 12-digit number to be printed as a barcode label: Sub ZEBRA_LABEL() This is not designed to work for as soon as the value is inputted, I was just testing to see whether the printer prints a BARCODE which is the most important part of this, so I used the code below which I lifted from here. I am looking for a macro or another way to print labels on a Zebra printer as soon as a value is inputted into a specific column in a spreadsheet. I am very much of a beginner with VBA so forgive any sloppiness.
0 kommentar(er)
