LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
XP XP is offline
external usenet poster
 
Posts: 389
Default Exract individual page ranges from sheet

Using Excel 2007 and Win XP;

I have several pages delineated by page breaks all residing in one sheet. I
am trying to obtain the cell address of, say, page 3. I figure this would be
the range address of the top left cell and bottom right cell in the range of
page 3 (which can most easily be seen in PageBreakPreview).

I tried using PrintArea, but that gives me the print range of the entire
sheet, I just need one page (I need to be able to get any individual page).
Can anyone please post some code that will enable me to do this?

Thanks much 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
How can Enter Page Numbers and/or page ranges separated by commas. d Excel Discussion (Misc queries) 1 December 3rd 08 03:41 PM
more than 2 secondary y axis with individual ranges of value Big G Charts and Charting in Excel 4 May 22nd 07 01:59 PM
How do I save an individual page in a workbook? Sharon Williams Excel Worksheet Functions 2 December 14th 06 02:14 PM
Individual Page Selection Chris Shaw[_3_] Excel Programming 1 July 11th 05 08:12 PM
Return an array of all page ranges in a sheet? slovical Excel Programming 1 February 4th 04 09:07 PM


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

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"