JBeaucaire help me with the following code. It works great, I have 14 ranges like this on the same spreadsheet and would like to print all of them based on the result in the target cells for the range of each to print.
I currently have a macro button to print each range as you can see. Is it possible to connect these? What I have tried is cutting the End Sub and then the Dim r As Long but get errors.
Please Login or Register to view this content.
Last edited by ed ayers315; 11-09-2009 at 03:47 PM.
Hi again Ed. Be sure to read through the Forum Rules so you can use and follow them effectively. For instance, you'll need to edit that post above and put code tags around that code you used. (Like I did below...)
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Sorry about the code brackets.
I plugged in your code; trouble with ranges that did not have a target number, the code error'd there.
Is there a way to jump to the next routine if an error is found?
You're saying some of the cells might be blank that are supposed to determine how many rows to copy? You'll have to build that test into each section then:
Please Login or Register to view this content.
Re: connecting macros
Thanks JB it works great!!!
Put another in the Solved Column
Last edited by ed ayers315; 11-09-2009 at 03:44 PM. Reason: Solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks