Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 21
Default How to select the last row before the page break on an Excel sheet

Hello. I would like to know if there is a VBA command to get the last row of
page no1 of a Excel sheet. The last row should be the one which is at the
horizontal page break of page no1. The same question for the 1st colomn in
page no1, the last colomn in page no1 and the 1st row of page no1.
Thanks a lot. regards. Michel
Reply
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
Excel 2007 Page Break Adjustments causes a page break each cell BKaufman Excel Worksheet Functions 2 September 10th 10 05:02 AM
how to remove the page break lines in a spread sheet, gypsie g Excel Discussion (Misc queries) 1 March 22nd 10 03:22 AM
how to set page break for continuous numerical sheet printing Woodbug Excel Discussion (Misc queries) 1 May 27th 09 03:29 PM
best approach? or select last row before page break erin Excel Programming 1 February 25th 04 04:36 PM


All times are GMT +1. The time now is 05:57 PM.

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"