Hello everyone
I have Data sheet ...
When clicked print preview there are four pages ..
I need to examine values in column G in each page ... If there are any value withing page greater than zero ,so the page to be printed
In the attachment : page 1 and page 3 should be printed out , and exclude page 2 and page 4 as in these two pages there ar no values greater than zero
Hope it is clear
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
When I looked at your workbook it was like a mirror image with the Column headers reversed?
The following should work. I am assuming that only numbers
will be in Column G!
Please Login or Register to view this content.
Thanks for help
First, I have 200 pages and it will be exhausted to determine the ranges for each page
Second, the code prints every page twice ..!!
Third, column G have other data in other positions not only numbers
Fourth, If possible using the text "Signature:" which existed at the end of each page I think this will be better
Thanks advanced
Please Login or Register to view this content.
Sorry Yasser, I left out one more If Check, probably would have printed how many cells in those ranges contained Data????
And I assumed you were only taking about One Sheet
Great it works now well
That's exactly what I need ...
But there is a problem >> I have in this sheet about 200 pages .... and it would be exhausted to put the ranges for each page ..
Is it possible to specify the ranges depending on the text "Total" or the text "Signature"?
Thanks for help
I am a little confused as to exactly what triggers whether to print or not To establish the Ranges of your Pages that are designated
print areas you could use the code below in a loop to determine the ranges. Suggest you send these results to a new sheet and separate the
individual ranges into an array for processing the print process.
Please Login or Register to view this content.
This issue can be solved if we could use the word "Signature" to determine the first and last row of the range of each page I suppose
Please any one can help me at this point.
I appreciate any help
I appreciate any help with that topic
Hi,
Please Login or Register to view this content.
Regards
Mr. Karedog
I'm very grateful of your great and continuous help in all my complicated issues
Thank you very much ..
Regards
You are welcome. I am glad I can help, while I still can.
Thanks for the reps.
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks