Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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:) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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:) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Determine if a PivotField is visible? | Excel Programming | |||
Determine upper visible corner of sheet | Excel Programming | |||
Determine page which row will print on | Excel Programming | |||
Programmatically determine if a control is .VISIBLE or not. | Excel Programming | |||
Help: Copying Visible Cells only to Visible cells! | Excel Programming |