tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,212
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone,
Maybe you can help?
I have a document
I want to print out the sheets i select
all pages are set up with print areas etc.
so heres what i need?
I have a list of all my sheet names down column H
In column J I have have all the sheets i want to print maked with an "a"
so i need a macro that can go down column H and if Column J of that row is an "a" mark it to be printed
then once it has all the sheets it wants to print selected, it create a PDF call "value of K12" and saved in the same folder we are currently in.
please help if you can thanks
Tony
Maybe you can help?
I have a document
I want to print out the sheets i select
all pages are set up with print areas etc.
so heres what i need?
I have a list of all my sheet names down column H
In column J I have have all the sheets i want to print maked with an "a"
so i need a macro that can go down column H and if Column J of that row is an "a" mark it to be printed
then once it has all the sheets it wants to print selected, it create a PDF call "value of K12" and saved in the same folder we are currently in.
please help if you can thanks
Tony