I want loop through only visible cells in a worksheet thats print area is variable and set a page break for every so many cells. Then I want to select that range and use it as my print area. Currently, I am not looping and have a helper cell with formulas telling my macro to start at that cell. My code is selecting the header column and creating one to many sheets for my print area. Please help!
Please Login or Register to view this content.
Try this code
Please Login or Register to view this content.
Thank you! That worked better than my last code. Still having an issue unfornately. Excel at my start row is automatically creating a page break any reason this is happening. I have two hidden rows and a header that repeates at the top? Is there anyway to change to the print area to start at the start row?
Last edited by tuc47285; 03-05-2015 at 04:41 PM.
I think it's better to attach your file to see it
I attached teh workbook.
I didn't get exactly what you want
But try to change this line
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks