Hand out once more...
Have a macro that creates a report of varying total number of rows, where final column is always "I". Struggling to include variable print area code... I have a suspicion that the setting of the printrange is working (?) but my last line is not then setup correctly to actually print it...? Please see below for current state, and I would appreciate any help!
Please Login or Register to view this content.
The following line doesn't look right to me, basically the range will be from A1:IA500, is that right?Please Login or Register to view this content.
EDIT, I just added your code to a workbook and I see that I am wrong about that. Sorry.
Last edited by Mordred; 08-15-2013 at 01:00 PM.
If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.
---Keep on Coding in the Free World---
After running your code, I did not encounter an error with what was printed. What exactly is going wrong for you?
Thanks Mordred, yes... there will never be more than 500 rows, but will always be fewer...
Did your test successfully print?
Hi fourmurphys
This is Code I keep in my ToolBoxPlease Login or Register to view this content.
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.
Well.... actually this does work... It was out of order in my code (too many copy/pastes). Thank you!
I have a new issue related to the last cell always being a merged cell and only printing the top row of that... but I think I need to start a new thread for that. Will mark this one solved. Actually should mark it... "I'm an idiot".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks