Jagat Pavasia
Active Member
- Joined
- Mar 9, 2015
- Messages
- 411
- Office Version
- 2021
- Platform
- Windows
DEAR SIR/MADAM,
I HAVE 3 PRINTER DRIVER INSTALLED IN MY COMPUTER.
ON OF THEM IS BROTHER LABEL PRINTER.
I WANT TO PRINT ON MY BROTHER PRINTER NAMED "Brother QL-800" IN SELECTED RANGE IS "A11:E19"
SO, I WANT MACRO THAT IF I SELECT MACRO & THEN AUTOMATICALLY SELECT MY BROTHER PRINTER AND INSTANT PRINT FROM "A11:E19".
(Printer should be automatically select "Brother QL-800" & then print)
PLEASE GIVE ME VBA CODE, I AM NEW IN VBA.
I HAVE 3 PRINTER DRIVER INSTALLED IN MY COMPUTER.
ON OF THEM IS BROTHER LABEL PRINTER.
I WANT TO PRINT ON MY BROTHER PRINTER NAMED "Brother QL-800" IN SELECTED RANGE IS "A11:E19"
SO, I WANT MACRO THAT IF I SELECT MACRO & THEN AUTOMATICALLY SELECT MY BROTHER PRINTER AND INSTANT PRINT FROM "A11:E19".
(Printer should be automatically select "Brother QL-800" & then print)
PLEASE GIVE ME VBA CODE, I AM NEW IN VBA.