Hi, I am very new to VBA coding and need some help. I'm looking for a code that selects range, prints to pdf and sends the pdf by e-mail.
In my sheet i have 7 cells that have a formula which give the cell a "X" if i want an range to be printed:
If I33 = "X" then select A1: S31 (I33 has a formula)
If I34 = "X" then select T1: AH31 (I33 has a formula)
I have 7 of these ....
What I'm looking for; if one or more of I33, I34, i35, I36, I37, I38 or I39 has an "X", the respective area (example A1:S31, there are 7 different ranges) should be selected, printed to one .pdf and sent by e-mail with the fields as :to, :subject and :text filled out. I also would like that .pdf be saved in a google drive folder. This vba code will to be used on different computers that all have access to the same google drive.
Thanks so much for any help that might come
In my sheet i have 7 cells that have a formula which give the cell a "X" if i want an range to be printed:
If I33 = "X" then select A1: S31 (I33 has a formula)
If I34 = "X" then select T1: AH31 (I33 has a formula)
I have 7 of these ....
What I'm looking for; if one or more of I33, I34, i35, I36, I37, I38 or I39 has an "X", the respective area (example A1:S31, there are 7 different ranges) should be selected, printed to one .pdf and sent by e-mail with the fields as :to, :subject and :text filled out. I also would like that .pdf be saved in a google drive folder. This vba code will to be used on different computers that all have access to the same google drive.
Thanks so much for any help that might come
