LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Select Cells in Print Area


Sean,

Thank you for your time and the reply. Great start!

I have problems only when I have multiple print areas on a sinlgle
worksheet. The previous code selects all the print areas, i.e. all the
pages, to copy.

Is there a way to have it only select the first page/print area of the
wks(1) to copy and then move to page2/second print area of wks(1) and
copy?

Thanks again!

- Chris


--
Chris Shaw
------------------------------------------------------------------------
Chris Shaw's Profile: http://www.excelforum.com/member.php...o&userid=25041
View this thread: http://www.excelforum.com/showthread...hreadid=385660

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can Excel automatically select print area on non-blank cells? N.F. Jackson[_2_] Excel Discussion (Misc queries) 1 April 3rd 09 07:03 PM
Set print area over locked cells toolman Excel Worksheet Functions 0 October 17th 08 05:04 PM
How to end/up end/across to select print area? Kevryl Excel Discussion (Misc queries) 4 October 9th 06 11:53 PM
Create a print macro that would automatically select print area? wastedwings Excel Worksheet Functions 7 August 22nd 05 10:36 PM
Macro to select the print area Gavin[_3_] Excel Programming 5 July 29th 03 02:58 PM


All times are GMT +1. The time now is 04:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"