VBA - set my print

Posted on 2012-12-26
Medium Priority
Last Modified: 2012-12-26
Hello All,

I have a vba issue. I have a sheet that has several Hidden columns and Rows. How do I set the print area so that it always sets print area from cell F1 down to the visible rows? For example:
if rows (3-25) is visible, the print area is set to whatever that’s visible in range F1: K25
If row (30 – 52 ) is visible then the print area is set whatever that’s visible in range F1: K52

Thank you
Question by:Rayne
LVL 39

Accepted Solution

Pratima Pharande earned 2000 total points
ID: 38720866

Author Comment

ID: 38721657
Thank you Pratima :)
That works great

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Manually copying shapes and their assigned macros one by one to a new location can be tedious, but if you use the Excel utility workbook attached to this article, the process will be much quicker and easier.
What to do if a split doesn't fit? Or a bunch of invoice lines must be rounded while the sum must match a total? It takes a little, but - when done - it is extremely easy to implement.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question