Hi - I'd really like to modify this awesome formula in this post to export 2 specific print ranges from only two separate worksheets in my workbook (instead of all worksheets)
Unfortunately, I'm lacking the VBA know-how...
(ps. Tried to post reply to this post directly, but got error message "thread doesn't exist.." etc).
Many thanks for you help!
http://www.exceltip.com/st/Copy_work...Excel/481.html
Is there any eason you cannot do it all in Excel without exporting to Word?
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Due to the way you want to use the function I would move the section that actually does the copying into it's own sub.
Then pass that sub a 'word document' as a destination, a range that you want placed in the document, and lastly whether you want a page break to follow it or not.
Please Login or Register to view this content.Obviously you need to specify the correct sheet names and ranges in the RED sectionsPlease Login or Register to view this content.
Last edited by Phil_V; 07-28-2009 at 09:21 AM. Reason: Added clarity of sections that would need changing
If you find the response helpful please click the scales in the blue bar above and rate it
If you don't like the response, don't bother with the scales, they are not for you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks