Lightkeepr
New Member
- Joined
- Apr 6, 2021
- Messages
- 27
- Office Version
- 365
- Platform
- Windows
I have nine worksheets in a file as follows:
SETUP (never printed out)
DATA (never printed out)
POT (never printed out)
PCR
PCOST
JSUM
PRA
DELTA
CSR
On sheet DATA in cells F174:K174 i have formulas that if the worksheet is to be printed the cell will have the sheets name visible. Using VBA, how would I get the sheet names that are visible in that cell range (ignoring the blank or "" cells) and pass them to the .PrintOut as the sheets to be printed together as one document?
SETUP (never printed out)
DATA (never printed out)
POT (never printed out)
PCR
PCOST
JSUM
PRA
DELTA
CSR
On sheet DATA in cells F174:K174 i have formulas that if the worksheet is to be printed the cell will have the sheets name visible. Using VBA, how would I get the sheet names that are visible in that cell range (ignoring the blank or "" cells) and pass them to the .PrintOut as the sheets to be printed together as one document?