The code below highlight the dynamic print area of page 2 (by another VBA):
where the top and below row can be determined by page break;
Please Login or Register to view this content.
but the left and right column has to be set manually after dynamic print area is set.
e.g. ".Resize(, 11)"
How to revise the VBA to highlight dynamic print area (of page 2 only)?
(i.e. determining the left and right column by VBA)
Use:
Please Login or Register to view this content.
Best Regards,
Kaper
PS. If the first page do not start from column 1 (because of setup of print area) try:
Please Login or Register to view this content.
Hi Kaper,
The VBA works if print area start from Column A.
If start from Column B, there is error message (translated from my Chinese Excel):
Execution error no. 9
Index of column/row out of range
Error occurs while using code from post #3 or #4?
If it's always column B use:Please Login or Register to view this content.
Hi Kaper ,
There is same execution error 9 - Index of column/row out of range.
But if the print range is extended to Column A (from B),
then Column B to right of page break is highlighted.
(it is not my expectation as highlighted area not match printed area and I don't want to print column A)
please attach small sample workbook
Hi Kaper,
I can't attach the excel file as the file (only 185KB) cannot be uploaded.
That file is not too big - why can't it be uploaded?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Upon my log out and then log in, please see the excel.
If there is no Vertical page breaks and last column is always M then:
Shall do the jobPlease Login or Register to view this content.
Hi Kaper,
I want the page to be set by HPageBreak and VPageBreak as the print range of each page may be changed.
Will you please attach a SMALL sample Excel workbook(s) (10-20 rows of data is usually enough)? Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).
1. Make sure that your sample data are truly REPRESENTATIVE of your real data. (If trere are typical cases like: all unique values/duplicates could occur, day/night, nobody present/several persons at once, before/on/past due, etc. - please show them all or at least indicate in text) The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.
2. Make sure that your desired solution(s) is/are also shown (mock up the results manually).
3. Make sure that all confidential/restricted information (either personal or business) like real e-mails, social security numbers, bank accounts, etc. is removed first!!
To attach an Excel file you have to do the following: Just before posting, scroll down and press Go Advanced button and then scroll down and press Manage Attachments link. Now follow the instructions at the top of that pop-up screen.
Please see attached excel file that print range need to be highlighted by VBA.
Sub zz()
Range("print_area").Select
End SubPlease Login or Register to view this content.
How to highlight page 2 only?
try this:
Please Login or Register to view this content.
Last edited by ikboy; 10-30-2017 at 11:23 PM.
Hi ikboy,
It's works for page 2 only.
How to revise VBA so that:
1. InputBox("Page(s) for highlight", , "1,3,5-6")
2. The input pages (e.g. 1,3) will be highlighted.
Please post new thread for new.
Thanks ikboy and Kaper.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks