A way to Determine visible cells on the page

M

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

Norman Jones

Hi Mark,

From the Immediate window:

? ActiveWindow.VisibleRange.Address

$A$1:$P$29
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Determine tje last visible row on the screen. 7
How to determine Last row of a Page in Excel 7
VB to get to top of page 2
Determine upper visible corner of sheet 2
Count Number of Visible Rows in Filtered View 2
Move/Scroll Specific Cell(Row) into the centre of the Screen ? 4
Detect Ink in a PowerPoint Add-In 0
Fitting a form to a larger screen resolution 0

Top