LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default setting print area to selected cells

Hi. Is there are way to set the print area based on the cells that are
currently selected/highlighted? So, this time I have the range A1:D27
highlighted and I want that to be the print area, but next time I want
B9:KE102 to be the print area. I've figured out how to have a macro
select the area I want, but don't know how to have a "flexible" print
area. thanks in advance

 
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
Setting TAB to navigate to selected Cells Only Corey Excel Worksheet Functions 3 May 29th 06 09:54 AM
Format worksheet to view only the print area cells in Excel jshoff271 Excel Discussion (Misc queries) 5 December 19th 05 07:37 PM
Active cell counting in particular print page (one sheet having different print area) ananthmca2004 Excel Worksheet Functions 1 November 24th 05 11:29 AM
Sorting Area with Merged Cells prizm1 New Users to Excel 3 September 10th 05 11:49 PM
Can't Clear Print Area GeorgeF Excel Discussion (Misc queries) 2 August 5th 05 06:10 PM


All times are GMT +1. The time now is 06:03 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"