nathanthomson11
New Member
I have a tracking file which generates a new barcode on each line-item as a new line is created. For example, I am entering data on line 3458, a barcode is generated on BE3458. I now want to create a macro button on BF3458 which I can click and it will automatically adjust the print area to BE3458 and print only the new barcode.
I could use the following code but there are a lot of entries on this sheet so I would need to enter it thousands of times and link to each button:
Sub PrintSomeCells()
Range("BE3458").PrintOut
End Sub
I could use the following code but there are a lot of entries on this sheet so I would need to enter it thousands of times and link to each button:
Sub PrintSomeCells()
Range("BE3458").PrintOut
End Sub