Hi friends,
1- Open enclosed file.
2- Run Macro1.
3- Run Macro2.
4- Look printing view of page. (There is a headings)
5- Run Macro3.
6- Look printing view of page. (There is no headings)---->This is my problem.
So, I need a macro like this;
Regards
Please Login or Register to view this content.
Sub DontForgetThese() If Your thread includes any code Then Please use code tags... If Your thread has been solved Then Please mark as solved... If Anybody has helped to you Then Please add reputation... End Sub
Hi Herry
What is it you wish your Print Area to be...the Entire Table with Headings?
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
Hi jaslake,
Yes it is correct.
But be careful that I dont want code includes Table name.
In other words ListObjects(1) must be located in the code.
Regards.
Hi Herry
Are you saying you won't know the Table Name?
Hi jaslake,
I found the solution.
Thanks anyway.
Have a nice day.
http://www.online-excel.de/fom/fo_re...zh=4931&h=4921
Have a nice day Herry
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks