Good morning all
can advice me for the following code i get from internet that will export sheet name summary to pdf file with name of value from B2
the problem now is
i try to change in code to fit range that i need in exported PDF file and print only range A1:C105 or end of row have value instead of C105
but not working
the code is
Please Login or Register to view this content.
Please Login or Register to view this content.
Good Luck...
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
Also....Add a comment if you like!!!!
And remember...Mark Thread as Solved...
Excel Forum Rocks!!!
Dear sintek
thank you so much for your very simple and smart code
i have some note
1- its not give message for file present or not , its overwrite without any message
2- PDF file created have whole range even empty row , can neglect empty row from range
If pdf already exists, what must happen?1- its not give message for file present or not , its overwrite without any message
Supply sample file and specify exactly what range must be exported...2- PDF file created have whole range even empty row , can neglect empty row from range
See Top Yellow banner regarding sample file...
1- if already exist , show box say file present if you need to overwrite or to save as with different name
2-as in attached photo you can see result of file that have empty row printed
the whole range is A1:C105 but not all the time this range have data sometimes like in attached example have only data till C56 and the rest is empty
Last edited by mazan2010; 05-29-2021 at 05:03 AM.
Images mean nothing!!!
As I said previous post...
Supply sample file and specify exactly what range must be exported...
See Top Yellow banner regarding sample file...
finally i find the error as i find some cell is merged in my file
than you so much for your help and solution
Thanks for rep + ...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks