nathanthomson11
New Member
- Joined
- Apr 4, 2019
- Messages
- 23
- Office Version
- 365
- Platform
- Windows
I'm not overly knowledgeable when it comes to VBA so I'm hoping someone can write me a quick VBA for this purpose. I have a long list of items in a tracking file, each line-item has a barcode in column D and a macro button beside each barcode in column E. I need a VBA code so if I click on the macro button in column E, it will print the barcode located to the left in column D.
The challenge is that there are hundreds of barcodes, each with it's own macro so the follow coding I have only works for 1 unless I make a module for each.
Sub PrintSomeCells()
Range ("D360").PrintOut
End Sub
Thank you in advance!
The challenge is that there are hundreds of barcodes, each with it's own macro so the follow coding I have only works for 1 unless I make a module for each.
Sub PrintSomeCells()
Range ("D360").PrintOut
End Sub
Thank you in advance!