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:)

A way to Determine visible cells on the page
 

Hi Mark,

From the Immediate window:

? ActiveWindow.VisibleRange.Address

$A$1:$P$29


---
Regards.
Norman


"Mark Stephens" wrote in message
...
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:)