June 17, 2021
Hello. I need assistance. I created a print button to print content of a specific cell in a row using VBA print command. But I want to replicate that button to print content of corresponding cell in each row...say I place print button on colunm K to always print content of adjacent column I on each row ie. print button on K1 prints I1, K2 prints I2, K3 print I3 etc. At the moment, if I copy the button on all column K, it will always print content of specific cell entered in the VBA eg I1. How do I replicate it for all the rows? Pls assist. Thanks.