|
-
Oct 26th, 2007, 12:26 AM
#1
Thread Starter
Hyperactive Member
[RESOLVED] Excel VBA - Print only "not empty" pages
Excel 2007, VBA
I need to print only pages with some text on it.
Blank pages are random and they exsist because i put page break each one row or each two rows in that sheet (i need to print one or two rows on each sheet). In sheet these blanke pages are hidden rows but because page break they printout blank.
Can i make loop and test condition something like this?:
For each page in pages (printpreview)
If page (printpreview) > 0 letters then
printout
End If
Next page
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|