A way to Determine visible cells on the page

[Mark Stephens]

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

 

[Norman Jones]

Hi Mark,

From the Immediate window:

? ActiveWindow.VisibleRange.Address

$A$1:$P$29