LinkBack URL
About LinkBacks
i have multiple pages at the same worksheet and i need to put macro button for each page
how to make this macro print the page which has the active cell
thanks in advance.
i have multiple pages at the same worksheet and i need to put macro button for each page
how to make this macro print the page which has the active cell
thanks in advance.
Hi meonly,
Try this, I have to admit I didn't test it well since my free time is limited today, but I believe this should work? You will need to adjust the sheet name in the code to the name of the sheet you are working in.
Please Login or Register to view this content.
Last edited by Arkadi; 01-21-2015 at 05:18 PM.
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
Edit: nevermind, read post incorrectly.
stnkynts, I assumed he wanted only a specific page within the worksheet's pages? I really overcomplicated if not, lol.
thanks for your time i am really gratefuller to youOriginally Posted by Arkadi
Hi meonly,
Try this, I have to admit I didn't test it well since my free time is limited today, but I believe this should work? You will need to adjust the sheet name in the code to the name of the sheet you are working in.
Please Login or Register to view this content.
i use active sheet instead of sheet name coz i have alot of pages
but it show error on this line :
If ws.HPageBreaks(i).Location.Row <= rng.Row Then
any idea!!!
yes it is , a specific page (which has active cell)
I don't get an error with Arkadi's code, it seems to be fairly sound. Here is another way of doing the same (Arkadi's code is actually a little more encompassing but may be more than you need)
Please Login or Register to view this content.
Thanks stnkynts
I could not figure out the reason for the error, I don't get it either when I try. I did not fully test, but did run the macro a few times without error. That said, I don't think I tried it when the sheet is completely empty...
Stnkynts any time you see flaws or inefficient code from me, I'm always happy to hear about it, love to learn
sorry your code now working very well without any inefficient ,its my mistake i didnt setup page brakesThanks stnkynts
I could not figure out the reason for the error, I don't get it either when I try. I did not fully test, but did run the macro a few times without error. That said, I don't think I tried it when the sheet is completely empty...
thank you very much for helping me and wish you all the best
this good is working great but it doesn't work on last page (that has the last page break line) its print the upper page instead of the current pageI don't get an error with Arkadi's code, it seems to be fairly sound. Here is another way of doing the same (Arkadi's code is actually a little more encompassing but may be more than you need)
Please Login or Register to view this content.
i wonder if u could edited
I really appreciate everything you've done to help me
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks