View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mark Stephens Mark Stephens is offline
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:)