LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 123
Default Print Range not connected

I want to print a range that is A1:F100 and M1:Z100. so basically i want to
print A1:Z100 but exclude columns G:L. i tried range naming the A1:F100 and
M1:Z100 as print_range and the name works but i can't use print_range as a
print area in my print macro.

this non-contiguous range name does work in macros when i'm asking to open
and close it but not as a print range.
is there a solution?
tami
 
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
Dialog Box for un-connected links Eric Excel Discussion (Misc queries) 0 November 18th 08 02:21 PM
VBA connected vs disconnected from network? TSW632 Excel Discussion (Misc queries) 1 November 14th 08 05:14 AM
Averaging cells not connected Gary New Users to Excel 3 October 19th 08 05:21 PM
hangs when connected Gerhard Adendorff Excel Discussion (Misc queries) 0 April 13th 07 06:56 AM
Print Blank Pgs - Preview margins outside print range dsm Excel Discussion (Misc queries) 0 October 25th 06 06:17 PM


All times are GMT +1. The time now is 10:01 AM.

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

About Us

"It's about Microsoft Excel"