I need those functions...

I need a way to get the address range of the cells that are currently
showing on the screen for a given worksheet. OR a way to know if a cell or
range of cells are currently "on the screen". Screen resolution and the size
of each cell will have to be taken into account.

I have thought about using API calls to get the screen resolution and then
using .height and .width to get the X,Y,H,W values of every cell's
(rectangle) then from that, calculate which cells are currently showing on
the screen.

Is there a better way?

I am trying to come up with some routines that can be used keep pertinent
data showing on the screen no matter how the user has their screen sizing
set. (with in certain boundaries of course, I.E. at least 15 rows and 4
columns or some preset limit; perhaps an upper limit too) I could also see
using this to know when to scroll the screen to keep a block of cells near
the center of the screen.

--
Regards,
John