LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 124
Default A way to Determine visible cells on the page

Hi,

I have a need to find out how many rows appear ont he users screen so i can
draw in a border on the bottom and also to poisition the first graphic on
the page (in the middle). Does anyone know if there is a way to do this, for
exapmle if the screen is showing full screen then the number of visible rows
increases of course. I don't really want to get so complicated but if
necessary can i detect the cscreen resolution of the users computer and then
adjust accordingly (having removed unecessary screen real estate such as
tool bars etc [restoring them on exit]).

Any ideas much appreciated, regards, Mark

PS Does anyone know how I can set it up so I receiver an email when someone
answers my post I think I had this feature years ago when I was very active
in the user group as I will be again:)


 
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
Determine if a PivotField is visible? Whitney Yiu Excel Programming 7 December 22nd 07 06:33 AM
Determine upper visible corner of sheet John Michl Excel Programming 2 May 4th 06 04:14 PM
Determine page which row will print on Fred Smith Excel Programming 0 July 22nd 04 05:49 AM
Programmatically determine if a control is .VISIBLE or not. Toby Erkson Excel Programming 2 April 16th 04 11:51 PM
Help: Copying Visible Cells only to Visible cells! Jay Jayakumar Excel Programming 0 July 9th 03 08:25 PM


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