Hello Guys,
I need some help from you. I set the next code for printing conditional pages from 1 Sheet, and it is not selct the pages after conditions.
The cod is :
Thx in advance.Please Login or Register to view this content.
Hello Guys,
I need some help from you. I set the next code for printing conditional pages from 1 Sheet, and it is not selct the pages after conditions.
The cod is :
Thx in advance.Please Login or Register to view this content.
Last edited by vlady; 01-21-2014 at 04:15 AM.
At a glance - it looks right.
May be ...
* in BXX you have texts not numbers? (they can look similar) ?
* "82 B1" is wrong name?
* your Sub ChangePrintArea() is in the worksheet code (shall be in standard module)
A good advice from http://www.excelforum.com/forum-rule...rum-rules.html is:
Post a workbook.
In attach you find my file.
Thx
Attachment 291775
You have not tried TWO of my advices - both true:
See attachment.
In the code of FORM sheet only
If you wish the print area to be decreased after some data is deleted - delete also line from the code (as the comment states).Please Login or Register to view this content.
In standard Module only:
Note, that I used right name for the worksheet!Please Login or Register to view this content.
For sure, the code above could be rewritten in more effective or more elegant way, but it works. So I leave it as is.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks