hi all
ive only just noticed this but when i print to pdf, the pdf is showing 69 pages and not just the 1 that is required. i cant see anywhere in this code where all or 69 pages is required all i see is just the range that i want.
Please Login or Register to view this content.
Maybe:
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Thank you ill give it a try when it get home from work
Strange but with your code alone it just prints half a page if i add a 1 after HOriginally Posted by xladept
it wants to print 3 pages lolPlease Login or Register to view this content.
Hi Learning,
Don't put anything immediately after the H - write it like this:
Please Login or Register to view this content.
i did that and all it showed me was half an invoice lolHi Learning,
Don't put anything immediately after the H - write it like this:
Please Login or Register to view this content.
Hi Learning.. Try this code. I presumed that Sheet15 is sheet number 15 & the other changes I made are in between the hash lines
Good luck
Please Login or Register to view this content.
Last edited by Philb1; 04-17-2015 at 10:01 PM.
sorry for delay in replying but i tried your code but for some reason its erroring out onHi Learning.. Try this code. I presumed that Sheet15 is sheet number 15 & the other changes I made are in between the hash lines
Good luck
Please Login or Register to view this content.
even though i have dates in therePlease Login or Register to view this content.
Last edited by Learning ExL; 04-19-2015 at 03:33 AM.
****SOLVED*****
many thanks sir
It's erroring out because Sheet15 in your code isn't sheet 15, it's sheet 7, it's also the only sheet that's not hidden.
Try this, I've removed all references to Ws15. I can't test it with your workbook because it's looking for external links
Please Login or Register to view this content.
Excellent.. You got in before I posted & thanks for the rep
your welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks